Selecting all the rows below your actual data. Right-click, delete cells.
(this is different than simply pressing the delete key). Save your workbook.
This should reset the used range of your worksheet.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ICTag" wrote:

Whenever a colleague updates a spreadsheet I've created it comes back
10MBytes large whereas it was originally only 50KBytes. It looks to me as if
the colleague accidentally adds tens or hundreds of thousands of empty rows.

How can I delete all rows below a certain row. Delete does not work. Copying
the real rows into a new worksheet loses the formatting. When I apply the
formatting from the big spreadsheet (paste formatting) I end up with hundreds
of thousands of rows again :-(

Any suggestions?
Tom