Hide contents of entire worksheet (Excel 2003)

Topic

New Reply

When you hide rows or columns in excel, you can select on either side and unhide the contents. If you select all of a work sheet and hide, how do you get the contents back. Undo was the only way I could but if you save, you lose that option.

Reply | Quote

Replies

You can still click on the square at the top left to select the entire sheet, or any row button to select any row and then do Format/Column/Unhide.

Reply | Quote

All the rows and columns are hidden and I can’t click on them.

Reply | Quote

Whe I hide all the rows and all the columns, the 1 “intersect” cell (in the upper-left) is still there to select. Selecting this and format- row – unhide (or format- column- unhide) should unhide the rows (or columns)

Steve

Reply | Quote

That worked—thanks.

Reply | Quote

Go to Format>Sheet>Unhide

Reply | Quote

Format/sheet—unhide is grayed out

Reply | Quote

I’d suggest that hiding the worksheet (with or without a password) is more efficient than hiding all the rows and columns

Reply | Quote