![]() |
Unhiding Rows in Excel
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 |
Unhiding Rows in Excel
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! ================================================== === "JMM" wrote in message ... 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 |
Unhiding Rows in Excel
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 "JMM" wrote in message ... 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 |
Unhiding Rows in Excel
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. "JMM" wrote: 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 |
Unhiding Rows in Excel
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. "RagDyeR" wrote: 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! ================================================== === "JMM" wrote in message ... 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 |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com