How to get rid of 'excess' rows?

  • Thread starter Thread starter ltg
  • Start date Start date
L

ltg

Hi all,

I noticed one of my spreadsheets was a really big file (500K) for
something that should have been very small.

So I opened it and noticed that even though I only have data in the
first 35 rows, the spreadsheet contains 9000+ rows. I imagine there
is some formatting or something that is telling Excel to keep all the
rows as part of my file, and I don't know how to get rid of the rows.

I can't just copy and paste the data into a new spreadsheet because I
have a lot of formatting in the rows/columns that I don't wish to have
to recreate.

Thanks!

BTW: OS is Win98, Excel ver97 SR-2
 
As long as you don't want to keep formatting etc in rows 36 down, then select
the Row header for Row 36 then do CTRL+SHIFT+DOWNARROW then do Edit / Delete.
Save and close the file then reopen.
 
Unless it's stating the obvious you may like to -

highlight all (well at least quite a number of) columns right of the last
column containing data and clicking on <Edit><Delete>
highlight all (well at least quite a number of) rows below the last row
containing data and clicking on <Edit><Delete>
take the cursor to A1 and <Save>

Check to confirm that it has deleted all unused columns and rows and repeat
as necessary.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top