Excel displaying all rows

Somehow I have done something in a spreadsheet that has resulted in 4,738 rows not being displayed. I have tried Show rows…no luck

Does Edit > Undo help.

Which rows are not displayed?

  • Select the row headers both sides of the hidden rows then click Format > Rows > Show
    SelectRowHeadersEitherSide
  • Click the View menu, is Freeze rows and columns highlighted? If so click it to toggle Freeze to off

Thank you for your suggestions. The problem has been solved!

For the benefit of others who have the same problem, perhaps you could say how the problem was solved.

1 Like

I went to View Freeze Rows and Columns and toggled the reference. The hidden rows reappeared. Thanks for the help!

1 Like