Navigation around spreadsheet

[Grogus]

I use my Ctrl+Home and Ctrl+End keys to navigate. If you delete the last row of data on the sheet and then press Ctrl+End the pointer will still go to the spot that used to be the last entry even though the cell is now empty.

 

[Mark W.]

Re-save the worksheet after the deletion.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q230998
This message was edited by Mark W. on 2002-10-29 17:32

 

[VoG]

This may help http://www.mvps.org/dmcritchie/excel/lastcell.htm