Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

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.