Rows "disappeared" from excel Spreadsheet

Question

I've been asked to investigate an Excel issue about "disappearing rows"

In a spreadsheet with several thousand rows , the first few hundred rows are now showing - it starts with a header row (row 387) - see below.

• There is no filter on
• I've tried resizing all rows - doesn't show "lost" data
• There aren't any macros in this spreadsheet.

Any ideas?

Thanks!

Answer 1

Select any cell, press (ctrl +a) twice,

1. then right click on any row number and click unhide

or 2) resize the rows hight.

or 3) Format>Row>Unhide

Answer 2

After clicking on the Select All button, you can right-click on one of the row numbers and select "Unhide"

You can also select row 387 and drag your mouse up slowly until you see a pop-up that tells you that you have selected 387 Rows (see the "21R" pop-up in the image below). Then right-click on row 387 and select "Unhide"

The other day I had somebody tell me that they couldn't unhide any rows that were hidden by filtering or manual hiding. They seemed to know what they were doing, so it sounded like a glitch. They saved the file, rebooted their computer, and the problem went away.

Answer 3

Try clicking on the select all button at intersection of row/column just below the Namebox then Format>Row>Unhide

Gord

Answer 4

Unfreeze pane from view menu and then unhide

Answer 5

Thanks for the replies.

I'm away on holiday for a while, I'll try your suggestions when I get back