Unhiding Rows

[Guest]

I have accidently hidden rows 1 through to 20 on my spreadsheet and saved the
file. When I opened it I found that I couldn't unhide them by right clicking
and selecting 'unhide' as this option wasn't available to me.
Can anyone help?

 

[wjohnson]

Go to the center of the top of row 21 at the corner of top row an
column A or whatever column is visible. Move your mouse slowly in tha
area and it should change from a large "PLUS" to something like th
following = when you see that, hold the left mouse button down and dra
down and it should resize those rows for you

 

[Guest]

How do I unhide rows 1 through to 20 though?

 

[Roger Govier]

Hi

Press CTRL+A to select the whole sheet
Format>Rows>Unhide

 

[Guest]

Many thanks

Hi

Press CTRL+A to select the whole sheet
Format>Rows>Unhide

 

[Dave Peterson]

Another way:

Edit|goto
type in A1:A20
format|row|Unhide

 

[smaruzzi]

Hi,

None of these suggestions seems to work on Excel 2008 for Mac.
Any clues?

Thanks, Stefano

 

[Dave Peterson]

Check to see if you can use Window|Unfreeze panes.
Then scroll to the left
if that doesn't work, then try the edit|goto stuff

If that doesn't work, then you may want to post in
news://msnews.microsoft.com/microsoft.public.mac.office.excel