Re: How to get rid of 'excess' rows?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 20:47:17 -0000

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. 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"ltg" <ltg@somewhere.com> wrote in message
news:k2ec401bd4ng7k0skgla9m2p6rgv7v798q@4ax.com...
> 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 spread*** 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 spread*** 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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004
Quantcast