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

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.

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ralph" wrote in message
...
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.