Hide Unhide
"Ragdyer" wrote in message
...
"Colin" wrote in message
...
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?
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".
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.]
--
David Biddulph
|