Thanks Shane.
That's a cool way of selecting the lines but it doesn't shrink after deleting.
I'll have to find our what he does.
Tom

"Shane Devenshire" wrote:

Hi,

1. Click the first row number you want removed
2. Press Shift+Ctrl+Down Arrow
3. Press Ctrl+- (control minus)

I would also consider doing this for columns, in which case step 2 would be
Ctrl+Shift+Right Arrow

All worksheets in 2003 and earlier contain 65,536 rows and 256 columns
whether they have anything in them or not.

The menu command for Deleting rows or columns is Edti, Delete (not Edit,
Clear,...)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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