how do i unhide all cells on an excel worksheet?

A

alliecallie

I selected my entire worksheet (by clicking the button in the upper-left
corner of the worksheet frame), then I right-clicked and choose Hide. I've
tried every trick I know to unhide the cells but nothing works. Does anyone
have a suggestion?
Thanks
 
B

bobclark

for all rows and columns left click the empty column to the left of the Aand
above the 1 then right click within the sheet itself then unhide
 
R

RagDyer

Maybe because the columns *aren't* hidden.

If you select the entire sheet and right click and choose "Hide", don't you
still see the column headers (A,B,C ...), while the row numbers are missing?

XL hides all the rows by default *unless* you tell it to hide the columns.

Whlie the rows are *still* hidden, click
<Format> <Column> <Hide>,
And see what happens.

NOW, do a <Format> <Row> <Unhide>,
And see what happens then.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Steve:

Strangely enough, I don't find Columns works.

Alf
 
Top