0

I noticed a strange behaviour in Excel 2007 files.

In an empty file, I select a number of rows and hide them. Then if I select the first and last row where all rows are hidden and unhide them, everything is fine.

If I want to do this in a filled Excel file, it doesn't work. Why?

1

Ok. I have it now. You have to select the first and last row then move the cursor to get a symbol with up and down arrows and one bar. Then doubleclick and all rows are unhided. If you have the symbol with up and down arrows and two bars you only unhide one row.

2
  • 1
    Potentially better: select, right click > unhide – Bob Mar 15 '12 at 16:25
  • For some reason unhiding only works if filters are applied and then removed. Strange. – user48604 Apr 10 '12 at 8:28
1

Try this:

Ctrl+A to select all rows and go to "Home > Format > Hide & Unhide > Unhide Rows"
  1. Make sure you don't have frozen panes
  2. Make sure there is no filter active
  3. sometimes rows are not hidden but have a very small height. Ctrl+A to select all rows and go to "Home > Format > Row Height" and fill in a height.

Hope it helps.

1
  • "Make sure there is no filter active" - figured this out on my own, but would have been much easier to have found this answer first. Also "No" is the operative word. If you have three filters on, then you have to remove all three before you can unhide multiple rows at the same time. – Karl Rookey Feb 5 '19 at 18:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.