+ 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
    324

    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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    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 (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

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

    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,289

    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
    324

    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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    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
    324

    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
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    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