How do I reset my vertical scroll and/or delete unwanted blank rows at the bottom?

[gatefire08]

My spreadsheet has 600rows and the vertical scroll bar ends at row 459424. I have attempted to delete all of the extra rows by holding SHIFT and CTRL, striking the down arrow then right-clicking on the left margin of highlighted row numbers and choosing delete.

But the unwanted rows are still there and my vertical scroll bar is not correlated to the 600 rows.

Please help!

Thank you

[daffodil11]

After you delete them, you need to save the book and then close and re-open it. The used rows will now be forgotten.