Ctrl-End

[Atenza]

Hi all,

I have a worksheet with 10 rows edited. If i press Ctrl-End, it will
highlight to row 10.
However, after i clean up or delete last five rows, and i press Ctrl-End, it
still highlight to row 10.
Is there a way to update the excel last used cell to row 5 so that Ctrl-End
will highlight to row 5?

Thanks

Martin

 

[Norman Jones]

Hi Atenza,

See Debra Dalgleish's notes on resetting the used range at:

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

 

[Dave Peterson]

You could try to reset the last used cell to what you think it should be:

Debra Dalgleish shows techniques:
http://contextures.com/xlfaqApp.html#Unused

 

[Atenza]

Thank you all of you!!!

You could try to reset the last used cell to what you think it should be:

Debra Dalgleish shows techniques:
http://contextures.com/xlfaqApp.html#Unused