Is it possible to reset the last used cell

John · Sep 13, 2003

In Excel 2000 control + end will go to the last cell in the worksheet.
However in on sheet this is somehow set at row 1029 and column EE so
something.

It should be row 250 column G

Is it possible to reset the position to which control + end jumps to.
If so I cannot find how to do it

IS Excel XP any different as we are upgrading soon.

John

Debra Dalgleish · Sep 13, 2003

There are some instructions here for resetting the used range:

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

Gord Dibben · Sep 13, 2003

John

Yes, it possible to reset the used range. See Debra Dalgleish's info on this
subject.

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

Excel XP is no different so save the info you get from Debra.

Gord Dibben Excel MVP XL2002