View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ICTag ICTag is offline
external usenet poster
 
Posts: 3
Default Excel 2003 - deleting trailing empty rows

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