CONTROL END

DDF · Jun 30, 2003

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 · Jun 30, 2003

There are some instructions here for resetting the last cell:

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

Gord Dibben · Jun 30, 2003

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

CONTROL END

DDF

Debra Dalgleish

Gord Dibben