CONTROL END

[DDF]

I HAVE A DATABASE THAT IS 500 ROWS LONG.
WHEN I PRESS CONTROL/END, I GET ROW 56000+?????
HOW DO I GET LINE 500 WHEN I PRESS CONTROL/END
tHANKS

 

[Debra Dalgleish]

There are some instructions here for resetting the last cell:

http://www.contextures.com/xlfaqApp.html#Unused

 

[Gord Dibben]

DDF

Go to row 501 then press SHIFT + END + DownArrow to select all rows to the
bottom.

Edit>Delete>Entire Row. Note: delete, not Clear Contents.

Do same for columns to the right of your data.

SAVE and CLOSE then re-open to see changes in CRTL + END

Gord Dibben Excel MVP - XL97 SR2 & XL2002