How do I delete extra rows at the bottom of an excel worksheet?

W

WSD Analyst

I have several worksheets that has thousands of empty rows which end up
making the overall workbook an extremely large file. Is there a way to
delete these rows without creating a new worksheet?
 
G

Gord Dibben

Excel worksheets have 65536 rows and 256 columns.

These cannot be deleted. They can be hidden.

Perhaps the "used range" Excel has estimated is not correct and appears too
large.

See Debra Dalgleish's site for methods of re-setting the used range on a
sheet.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Mon, 27 Sep 2004 10:37:02 -0700, "WSD Analyst" <WSD
 
G

Guest

If it's the same cells (rows or columns) in all the
sheets, first select each sheet by using the ctrl key and
clicking each tab, or (if consecutive sheets) click the
first sheet then use the shift key and select the last
sheet; click in the first blank cell, then hold down the
shift & ctrl keys at the same time and hit the end key.
This will highlight the offending cells (rows or
columns). Right click in highlighted area & select delete
from the menu. Then ctrl-home ctrl-s. To test to make
sure sheet(s) cleared, ctrl-end. The highlighted cell
should now stop at the last ACTIVE cell in the sheet.
 
Top