Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Mar 2009
    Posts
    29
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Why Excel autoselect multiple cells?

    Occasionally when I select a cell in Excel it will automatically select another 2 or 3 cells. I am not sure how to clear this up and do not know what I am doing to cause it.
    I just need to know how to "unselect" these automatic multiple or cause them not to happen in the first time.
    thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Do you have merged cells?If so unmerge them. You can use "Center across selection" instead of merging for similar effect.Steve

  3. #3
    Lounger
    Join Date
    Mar 2009
    Posts
    29
    Thanks
    1
    Thanked 0 Times in 0 Posts
    no there is no merge of the cells selected

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach an example file which demonstrates the issue and explain what must be done to see it?

    Steve

  5. #5
    Lounger
    Join Date
    Mar 2009
    Posts
    29
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I can not make it happen - it just happens on it's own. Next time it happens I will send to you. Usually selects 3-4 additonal cells downward from the one I selected
    thanks

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    Pressing the [Esc] key generally cancels an unwanted action.

    Are you selecting a cell with the mouse, or are you using the keyboard 'arrow keys' to select a cell when this happens?

    Have you accidently turned on 'sticky keys'????

    zeddy

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Are you using Excel 2007 and which view are you using? (Normal, Page Layout, Page Break Preview)
    Regards,
    Rory

    Microsoft MVP - Excel

  8. The Following User Says Thank You to rory For This Useful Post:

    ccjohansen (2012-02-06)

  9. #8
    Lounger
    Join Date
    Mar 2009
    Posts
    29
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The view was the key. It was on Page Layout when multiple cells would select. When I switched view to Normal the multiple selection stopped. thanks so much

Tags for this Thread

Posting Permissions

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