How to Hide Sheets in Excel

Replies to This Discussion

Permalink Reply by preetam chandra on January 11, 2010 at 6:41am

Go to the particular sheet. Click format( on top), sheet, hide.
To unhide, click format, sheet,unhide.

Preetam Chandra

▶ Reply to This

Permalink Reply by Duncan Williamson on January 11, 2010 at 2:20pm

don't know why you want to do this but PLEASE don't share your files unless you tell people there are hidden things AND you and/or they expect to add to or develop the file. Been there and done that and it's a nightmare!!

Duncan

▶ Reply to This

Permalink Reply by Venkat Rajesh Reddy on January 12, 2010 at 9:12am

yes you can, right click on a particular tab and choose option

▶ Reply to This

Permalink Reply by Pranay on January 13, 2010 at 3:09pm

Hi, Go to format - Sheet- hide

▶ Reply to This

Permalink Reply by MOHIT BAID on February 19, 2010 at 6:24am

Hi

This process cannot be followed in Office 2007, but instead we have to follow the process provided by Mr. Marshall.
I hope all confusions are solved.

▶ Reply to This

Permalink Reply by Marshall on February 17, 2010 at 10:05am

Hi.
To hide a sheet, just put your mouse on the page you want to hide, then right click your mouse and you choose (Hide). To unhide a page, do the same, a menu will appear and you would be able to choose the page that you want.
Hope it helps.

▶ Reply to This

Permalink Reply by MOHIT BAID on February 19, 2010 at 6:21am

Hi
Yes, we can do that way but it is possible only in Ms Excel 2007 & above and not applicable for Office 2000

▶ Reply to This

Permalink Reply by Dipu James on February 19, 2010 at 3:05pm

alt o h h

▶ Reply to This

Permalink Reply by moridaiya on February 24, 2010 at 11:32am

If you want to hide in system you must use vba.
......
sub hidden()
Sheets("SampleSheet").Visible = xlVeryHidden
end sub

.....

sub unhide()
Sheets("SampleSheet").Visible = true
end sub

▶ Reply to This

Permalink Reply by Chandra Sekhar Pamidi on March 2, 2010 at 3:04am

select the respective sheet and right click on it and you can view some options, on that you may opt for "hide"

▶ Reply to This

Permalink Reply by Sachin Shriram Gogate on March 7, 2010 at 1:15am

Select the sheet using CTRL button & Mouse.

Press CTRL key & select sheets.
Release CTRL key than

Go to Menu Format-Sheet-Hide.

It will hide all sheets which you select

▶ Reply to This

Permalink Reply by P.VIJAYKUMAR on March 30, 2010 at 7:48pm

If using excel 2007 you can directly right click on he sheet tab which you want to hide and select hide option to hide the selected sheet. If using older versions got to the format tab in the manu bar and the go to sheet ,then select hide from the available options.

▶ Reply to This

• ‹ Previous
• 1
• 2
• Next ›
• Page