ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unhiding Rows in Excel (https://www.excelbanter.com/excel-worksheet-functions/142445-unhiding-rows-excel.html)

JMM

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

RagDyeR

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



Paul B

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




JMM

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


JMM

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