How do I prevent Crtl+End moving to a cleared cell?

[Guest]

We know that Ctrl+End moves to bottom right 'active' cell in an Excel
spreadsheet. However, after working anywhere further down the sheet and then
clearing or deleting, Ctrl+End will always move to the last cleared cell. I
just want to move to the last cell containing data.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)