+ Reply to Thread
Results 1 to 11 of 11

How to unselect?

  1. #1
    Registered User
    Join Date
    09-04-2007
    Posts
    12

    How to unselect?

    I do I unselect a cell when I had previously selected it?

    I am unable to do this by holding down ctrl and right clicking.

    thanks

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    As far as I know, you must select something else to deselect a cell. Something must always be selected: cell, range, object (text box, drawing object, etc.).

    HTH

    Jason

  3. #3
    Registered User
    Join Date
    09-04-2007
    Posts
    12
    You should be able to just right-click on a cell while holding CTRL to unselect but it doesn't work.

    Any other suggestions?

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon dorian86

    Excel doesn't offer a way to deselect cells once they have been selected. However, you can download my free add-in via the link below, and once installed go to Ultimate > Range Toolbar which will give you a custom built toolbar to enable you to manipulate selected ranges (move range, extend range etc). There is a button on here that will deselect any cell for you.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  5. #5
    Registered User
    Join Date
    09-04-2007
    Posts
    12
    Thanks for the link but it was unable to load. Perhaps the link is broken.

    let me know thanks.

    P.S. does your add on work for the newest excel program?

  6. #6
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi dorian86

    Thanks for the link but it was unable to load
    I've just checked the link and it seems to be working fine - it can be a bit slow sometimes though. Unless you're on a company machine, it may be blocked.

    does your add on work for the newest excel program?
    If you mean XL2007 then probably not, but I can't be sure as I don't have access to this. As soon as I do will probably look into updating it.

    HTH

    DominicB

  7. #7
    Registered User
    Join Date
    09-04-2007
    Posts
    12
    Hello,

    I am using a fast internet connection and not on a company machine and the link never display the website.

    I would check the link, it should not load up that slow unless your using a poor hosting provider.

    I have the newest version of excel so I don't think this would work.

    thanks

  8. #8
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Nope, it's not an issue with the link; I can see it here at work.

    Jason

  9. #9
    Registered User
    Join Date
    11-23-2008
    Location
    ontario, canada
    Posts
    1

    Just...

    Just double-click the cell and it will be inactive.

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Just double-click the cell and it will be inactive.
    Welcome to the forum, Seniorboogie.

    That would be nice if it were true, but it doesn't drop a cell from a selection.
    Entia non sunt multiplicanda sine necessitate

  11. #11
    Registered User
    Join Date
    04-21-2014
    Location
    Napa, CA
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: How to unselect?

    I just selected a range of Objects by holding down the shift key. I used Ctrl + Right Mouse click and was able to deselect one of the objects....

+ 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