Ctrl+End goes MUCH farther than useful

[rhinomon]

Is there a way to limit where Ctrl+End goes?
It would be awfully nice if it went to the last used
cell . . .

 

[JulieD]

Hi

it goes to the last place that was used

so what you can do is delete all the rows after your current last used cell,
once you delete them close the workbook, saving it & reopen, this should
reset your ctrl & end.

Cheers
JulieD

 

[David McRitchie]

Excel sets a high water mark each time you insert rows or columns.
It would be an understatement to say that Excel does not do a good
job of resetting the limit when you delete rows or columns .

You can use a macro to attempt a fix of all of the sheets in your workbook
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
if in a particular sheet you want to identify a particular cell as the
lastcell you can delete the rows and columns past that cell, and
reset the last used cell
http://www.mvps.org/dmcritchie/excel/lastcell.htm#lastcell

You do want a correct lastcell indication for your worksheets, or
you files are unnecessarily large, and you print lots of paper
with no data.