Struggling with this problem, which no doubt has a simple solution.

The sheet I am working on has, for some reason, expanded all the way down to
something like row 65,000 even though there is no data in any of the fields
past row 200. This has obviously increased the size of the file, and I can't
figure out how to remove the additional rows.

Any help would be appreciated

Highlight the rows you don't want (201 to 65,536), right click and
select Delete, then save the spreadsheet.

shakey1181 Wrote:
Struggling with this problem, which no doubt has a simple solution.

The sheet I am working on has, for some reason, expanded all the way
down to
something like row 65,000 even though there is no data in any of the
fields
past row 200. This has obviously increased the size of the file, and I
can't
figure out how to remove the additional rows.

Any help would be appreciated

hi shakey1181,

if you have the time you may be interested in this also

http://www.mvps.org/dmcritchie/excel/lastcell.htm

oldchippy


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=572572

tried that, doesn't work, the rows just stay as they are


"Dave O" wrote:

Highlight the rows you don't want (201 to 65,536), right click and
select Delete, then save the spreadsheet.

The rows won't disappear, but after saving and in some cases, closing and
re-opening, the used range will be down to row 200.


Gord Dibben MS Excel MVP

On Thu, 17 Aug 2006 04:41:01 -0700, shakey1181
wrote:

tried that, doesn't work, the rows just stay as they are


"Dave O" wrote:

Highlight the rows you don't want (201 to 65,536), right click and
select Delete, then save the spreadsheet.