Deleting excess rows from a spreadsheet

[TumbleWeed on Platte]

Some of my spreadsheets have expanded to over 65,000 rows (I don't know what
causes that). When only the top 500 rows contain data, the vertical
scrollbar is practically useless. How can I remove the excess 64,500 rows
from the spreadsheet?

 

[Gord Dibben]

Select and delete all rows below and all columns right of your data range.

Do not just "clear contents".

Save the workbook to reset the used range.

In older versions you had to save, close then re-open to see changes.


Gord Dibben MS Excel MVP


On Fri, 2 Jan 2009 08:30:02 -0800, TumbleWeed on Platte <TumbleWeed on