View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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.