Too many lines at the bottom

[oliv]

Hello Excel 2000 gurus,

One day I found that approx. 3000 empty lines were
populating my Excel file. They are actually here, since
the box in the up-down scrollbar is tiny and I have only
~50 lines of data. And they also eat up space: the sheet
is ~400k.

In fact, if I copy the real data in a new sheet and
save it, I can see the size difference.

The problem is, I can't manage to delete these blank lines
using edit/delete or whatever regular method.

Strange pb isnt it ? And thanks in advance for the hint.

 

[Richard Choate]

Delete the excess rows and columns outside of your used range and then save.
Don't delete all the way to 65,535, just the extra problem rows and columns.
Richard Choate

Hello Excel 2000 gurus,

One day I found that approx. 3000 empty lines were
populating my Excel file. They are actually here, since
the box in the up-down scrollbar is tiny and I have only
~50 lines of data. And they also eat up space: the sheet
is ~400k.

In fact, if I copy the real data in a new sheet and
save it, I can see the size difference.

The problem is, I can't manage to delete these blank lines
using edit/delete or whatever regular method.

Strange pb isnt it ? And thanks in advance for the hint.

 

[Ken Wright]

Select all the rows below your data by clicking on the row headers and dragging down. Now hit
CTRL & - together (CTRL & Minus Sign) to delete the actual rows and not just the contents. Save
the workbook, close it and then re open it. That should fix it.

 

[Dave Peterson]

And Debra Dalgleish has some pictures and techniques for resetting the last used
cell at:
http://www.contextures.com/xlfaqApp.html#Unused