Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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.

share|improve this answer
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

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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