Hide Unhide

C

Colin

An easy one for you guys:

I know how to hide a section of my sheet (in my case the top few rows) by
selection the section then right clicking and choosing hide; but how do I
unhide the selection?
Thanks
Colin
 
C

Carim

Hi Colin,


Guess what ... with Unhide ...

but the trick is that the cell menu becomes available, only when you
cursor is well positionned ... symbol looks like the column width wit
a blank line in the middle ...

HTH
Cari
 
R

Ragdyer

It sometime becomes a problem when you hide the *first* column (A) or Row
( 1 ) to select them to "unhide".

One trick to select hidden cells is use "GoTo".

Say you've hidden Row1 to 5.

Select *all* of Row6 by clicking in the row header,
Hit <F5>
Type
1:1
in the reference box,
Hold <Shift>
Hit <Enter>
Right click anywhere in Row6 and choose "Unhide".
 
D

Dave Peterson

Another way...

Select a couple of cells in those hidden rows.
Edit|goto|type the address (like A1:A4)
then
Format|row|unhide
 
D

David Biddulph

It sometime becomes a problem when you hide the *first* column (A) or Row
( 1 ) to select them to "unhide".

One trick to select hidden cells is use "GoTo".

Say you've hidden Row1 to 5.

Select *all* of Row6 by clicking in the row header,
Hit <F5>
Type
1:1
in the reference box,
Hold <Shift>
Hit <Enter>
Right click anywhere in Row6 and choose "Unhide".
Click to expand...

An alternative is to click in the top left box (to the left of A, and above
1), & to use Format/ Row/ Unhide.
[This would, of course, unhide any hidden rows anywhere in the sheet.]
 
Top