+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    356

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

    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?

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

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

    try
    • clear all (ribbon - Home - Editing group)
    • save & close
    • re-open
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    356

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

    Please clarify how to do:

    clear all (ribbon - Home - Editing group)

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>>>Tamilnadu>>>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,341

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

    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.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  5. #5
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    356

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

    Thanks to sandy666 and Sixthsense for suggestion.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

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

    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
    Last edited by sandy666; 12-08-2017 at 12:29 AM.

  7. #7
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    356

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

    Thanks again to sandy666.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

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

    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1