+ Reply to Thread
Results 1 to 3 of 3

Deselect all cells in range except top left cell

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Tallahassee
    MS-Off Ver
    Excel 2010
    Posts
    30

    Deselect all cells in range except top left cell

    Is there a keyboard shortcut for the following?

    I have a range selected (A4:C15)

    I would like to deselect the range and make A4 the active cell. Is this possible without a macro?

    With a macro, one could use:
    Application.Goto Selection.Cells(1)

    I generally select a large number of cells and would like to go back to the start cell in the range. I could do it by pressing the left and right arrow keys but is there a shortcut that will allow me to do the same?

    I am using Excel 2007.

    Thank you.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Deselect all cells in range except top left cell

    Am I missing something?

    Why not Click on cell A4?

    You can Make A4 a Named Range then you can select goto, to take you there.

    Pressing Ctrl and G and an arrow will move you quickly around the worksheet.

    Pressing Cyrl G and Home takes you to A1.
    Last edited by mehmetcik; 04-13-2013 at 04:41 PM.

  3. #3
    Registered User
    Join Date
    01-10-2013
    Location
    Tallahassee
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Deselect all cells in range except top left cell

    Mehmet, thanks for your reply. I just wanted an easy way to go back to get rid of the selection but stay at the anchor cell.

    SHIFT + Backspace will do the trick.

    This key combination will remove the selection but keep the cursor at cell currently active.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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