How to reset excel for Ctrl-Shift-End to find updated last used cell?

[london7871]

Upon deleting the data/format of last used cell, Ctrl-Shift-End still regard this as last used cell.
How to reset excel so that the updated last used cell can be found?

[sandy666]

try

• clear all (ribbon - Home - Editing group)
• save & close
• re-open

[london7871]

Please clarify how to do:

clear all (ribbon - Home - Editing group)

[:) Sixthsense :)]

Refer the below link to know how to do it in VBA

http://www.globaliconnect.com/excel/...t&view=article

Please Login or Register  to view this content.

[london7871]

Thanks to sandy666 and Sixthsense for suggestion.

[sandy666]

select cell ("last used")
then on the ribbon
select Home tab
then go to the Editing Group
then select Clear
then click Clear All

clear.jpg

[london7871]

Thanks again to sandy666.

[sandy666]

You're welcome