Unhide Rows

[Notanothersecond]

Hello!

I have created a spreadsheet with 36 rows. However, when I recently opened the application, I now have over a million new rows. After row 17 it goes straight to row #1,000,000. I can’t view rows 18-36. I have tried to select all the rows and then click unhide. However nothing is working. Please help!

 

[FDibbins]

maybe try adjusting the row height?
highlight from row 15 to 40, RT-click , select Row Height, and enter, say, 15

 

[My Aswer Is This]

You said:
I have created a spreadsheet with 36 rows.

Do you mean 36 rows of data?

Excel 2013 has about 1.5 million rows.
So if you:"created a spreadsheet with 36 rows."

That means you some how deleted 1.5 million rows minus 36

 

[Fluff]

@Notanothersecond
Welcome to the board.

If FDibbins solution doesn't work
Select the sheet in question & run this

Sub Chk()
    With ActiveSheet
    MsgBox .ProtectContents & vbLf & .AutoFilterMode & vbLf & .Rows(50).RowHeight
    End With
End Sub

What does the message box say?