unhide rows

Christy · Mar 15th, 2002, 08:15 PM

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 · Mar 15th, 2002, 08:22 PM

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

Christy · Mar 15th, 2002, 08:28 PM

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

kwaring · Mar 15th, 2002, 08:35 PM

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 · Mar 15th, 2002, 08:40 PM

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 · Mar 15th, 2002, 08:46 PM

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

Christy · Mar 15th, 2002, 08:49 PM

Thanks George, but that didn't work either.

Anne Troy · Mar 15th, 2002, 09:22 PM

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 · Mar 15th, 2002, 09:26 PM

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!!

Mar 15th, 2002, 09:22 PM	#8
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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) __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 08:15 PM	#1
Christy New Member Join Date: Feb 2002 Location: Christy Posts: 13	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

Mar 15th, 2002, 08:22 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	select the gray cell next to A and above 1 then unhide

Mar 15th, 2002, 08:28 PM	#3
Christy New Member Join Date: Feb 2002 Location: Christy Posts: 13	I tried that, it doesn't work. Any other ideas?

Mar 15th, 2002, 08:35 PM	#4
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	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)

Mar 15th, 2002, 08:40 PM	#5
Christy New Member Join Date: Feb 2002 Location: Christy Posts: 13	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!!

Mar 15th, 2002, 08:46 PM	#6
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Press F5 and enter A1 then go to Format/Rows/Unhide

Mar 15th, 2002, 08:49 PM	#7
Christy New Member Join Date: Feb 2002 Location: Christy Posts: 13	Thanks George, but that didn't work either.

Mar 15th, 2002, 09:26 PM	#9
Christy New Member Join Date: Feb 2002 Location: Christy Posts: 13	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!!