Unhiding Rows in Excel

[Guest]

I opened a worksheet and notice row 2 is hidden, I've tried the conventional
way of choosing 1 & 3 and Unhide, I've also tried choosing teh entire
worksheet and Unhide, neither did the trick

 

[RagDyeR]

Hiding a row changes it's height to 0.
Unhide changes *only* zero height rows.

Your row might have a height of 0.5 or 0.25, which just about makes it not
visible.

Try selecting Row 1, and drag down to select Row 3, then right click in the
selection and choose "Row Height" and enter 13, and hit <Enter>.


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I opened a worksheet and notice row 2 is hidden, I've tried the conventional
way of choosing 1 & 3 and Unhide, I've also tried choosing teh entire
worksheet and Unhide, neither did the trick

 

[Paul B]

JMM., is the height set to 0?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thanks for the advice, I finally got it to work when I clicked on the first
cell and then Shift End Down and grab all the rows, then I did an unhide. It
didn't work before clicking on the button above row 1. Still not sure of the
issue. Thanks again.

 

[Guest]

Thanks for the advice, I finally got it to work when I clicked on the first
cell and then Shift End Down and grab all the rows, then I did an unhide. It
didn't work before clicking on the button above row 1. Still not sure of the
issue. Thanks again.