64000 Blank Rows in a sheet?

  • Thread starter Thread starter John Gilbert
  • Start date Start date
J

John Gilbert

Hi All,
I've been seeing extremely large Excel files showing up,
so I looked at several workbooks to see what was in them.
I found many with only 500 rows of data, but the sheet was
65000 rows long. Is there any way to stop this from
defaulting, or fix it in the Excel workbook?

Thanks for any help!
 
Select everything beyond the date, i.e. if the data is using A1:S500, select
everything to the right of S all the way to IV and do edit>delete,
select everything below row 500 to 65536, do edit>delete, save the file..
 
I believe you can highlight all of the empty rows and
click Edit and Delete. It's been my experience that this
will reduce the size of the spreadsheet file.
 
Hi John,

You might want to investigate a program called "Fast Excel" at
www.decisionmodels.com

He has a utility as part of his program called Clean Workbook that helps to
reduce the size and increase speed.

Regards,
Kevin
 
John

ALL worksheets have 65,536 rows. Re-setting the "used range" will not get rid
of those rows. Just render them "not in use".

Gord Dibben XL2002
 
Hi Gord,

<<Re-setting the "used range" will not get rid of those rows.>>

By size, I was referring to kb not row size. In John's original message he
stated, "I've been seeing extremely large Excel files showing up."

So resetting the used range might assist in decreasing the file size.

I just want to be sure we conveying the same message: resetting the used
range is a good idea.

Regards,
Kevin
 
All Excel sheets have 65536 rows as well as 256 columns (thru IV)

You need to see how much is in your active areas -- do control+end. This should
take you to the bottom right cell of data. If it does not, move your cursor to
what is the actual end, Select all columns to the right and Delete Column, put
your cursor 1 row below your last data row, Select all rows to the bottom,
Delete Rows, Save and close your workbook, the size should decrease if it was
inflated.



: Hi All,
: I've been seeing extremely large Excel files showing up,
: so I looked at several workbooks to see what was in them.
: I found many with only 500 rows of data, but the sheet was
: 65000 rows long. Is there any way to stop this from
: defaulting, or fix it in the Excel workbook?
:
: Thanks for any help!
:
 
Kevin

I did notice the "large Excel files showing up" and your response was correct.

I just tacked the rest on in case OP thought he could reduce the actual number
of rows in a worksheet.

We get a few posters that think the extra rows should be "removed" because
they don't need them. Like removing/deleting extra worksheets.

Gord
 
Back
Top