Comments on: How to hide and unhide rows in Excel

If you want to prevent your users from wandering into parts of a worksheet you don't want them to see, then hide such rows or columns from their view. The tutorial shows how to quickly hide and unhide rows in Excel using the ribbon, mouse or keyboard shortcuts. Continue reading →

Comments page 2. Total comments: 39

  1. how to delete blank rows in my excel data except rows that aren't completely blank

  2. Amazing, the most comprenhensive information I have found, one of the tips solved my problem. Thanks a lot!

  3. Thank you very much for this information. Always appreciate those who extend the effort to those who wish to learn.

    Roy

  4. I have 530 rows hidden and I don't want to sit and double click 530 times to unhide ALL of them. Is there not a way to unhide a rediculous number of hidden rows all at once?

    1. No???

    2. I have same problem. I still cannot unhide Rows even I have done every steps in this suggestion.

      1. Use CTRl+Home on your keyboard. Then left-click the gray box that has the bottom right-corner arrow in it (found directly under the A1 cell name box). This will select the entire worksheet. Move cursor over any Row Number and right-click, then select Unhide. You can do the same to Unhide all columns - just move cursor over a column letter and right-click.

        1. Thanks a lot it works. I have tried.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)