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