unhide rows

[Christy]

Hello!
I hid rows 1 through 6 and now I can't unhide them. "Help" tells me to select rows on either side of the hidden rows, of course there isn't a row before row 1 to select. Is there any way to unhide these rows?
Thanks so much!
~Christy

 

[Paul B]

select the gray cell next to A and above 1 then unhide

 

[Christy]

I tried that, it doesn't work. Any other ideas?

 

[kwaring]

click on the cell stated above to select the whole sheet then right click on the border between that cell and the one next to it and then click unhide (make sure you get the resize icon before you right click)

 

[Christy]

Hi Kwaring, I tried that with a new file and it worked, however, on my existing file it does not work. I cannot get the resize symbol until after row 7 or column A. uuuugh!!

 

[GeorgeB]

Press F5 and enter A1 then go to Format/Rows/Unhide

 

[Christy]

Thanks George, but that didn't work either.

 

[Anne Troy]

Christy, I suspect your rows aren't hidden at all, they just have a zero or very small row height.

Try hitting F5 and type in:

a1:a6

Hit Format-Row-Height and type in 12.75 (the default row height)

 

[Christy]

Thanks everyone - I finally got it! I had to select the entire sheet, hide it, then unhide it-!!!
Thanks so much for all your help!!