I was given an Excel spreadsheet which I opened with Excel 2016. It seems to have some rows which are hard to access: in the screenshot below, you can see the row numbers jump from 2 to 338 and from 343 to 375. There is data in these rows that I want to access. The document properties (second screenshot) says that there are hidden rows. I tried selecting the entire spreadsheet and choosing Unhide, or selecting the entire spreadsheet and setting all row heights to 20 pixels, but these rows won't appear.

What is going on, and how can I get all rows to appear?

enter image description here

enter image description here


Have you tried unhiding the rows programmatically, to see if that works? You can do it with a VBA macro like this:

Selection.EntireRow.Hidden = False
  • @KAE Disregard my answer... I didn't see yours until after mine was posted. – freginold Aug 9 '17 at 14:12
  • 1
    I always like a programming solution so I am accepting it. – KAE Aug 9 '17 at 17:15

I just stumbled across this answer which allowed me to see the missing rows. I cleared the Filter, and all rows appeared. [I am answering my own question in the hopes of helping another person with this issue, but will delete the question if that's more appropriate.]

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.