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 Charlene Khisa on February 22, 2010 at 11:17am

hi,
simply select the sheet you want to hide and click on format on the Menu bar and click on Sheet-Hide. to hide a number of excel sheets, hold down the control button select the excel sheets you want to hide, click on format-sheet hide. i hope this will be of help. Best Wishes

▶ 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