1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel selects multiple cells in spreadsheet instead of single

Discussion in 'Business Applications' started by eliztur, May 5, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. eliztur

    eliztur Thread Starter

    Joined:
    May 5, 2010
    Messages:
    3
    I am working in a very large spreadsheet and am having a problem with selecting individual cells. If I put my cursor in one cell it selects 6 more cells to the right as if they were merged while they are not. I am unable to copy formulas out of the single cell as it wants to select all 7. I don't know if it is a bug or what, but it is my 5 year financials and can't start all over. Does anyone have any ideas of what might be wrong? Please help!
     
  2. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,887
    Is this on 2007 - theres quite a lot of this problem report across the web, cells above or below being selected and also cells left and right being selected , and does not seem to have a final answer, that I have found. I have no problem with 2003 at all - but do not have 2007 anymore available.

    a work around I saw was to:
    right click and the menu pops up and then immedaitely left click then just the one cell is selected
     
  3. eliztur

    eliztur Thread Starter

    Joined:
    May 5, 2010
    Messages:
    3
    Thanks. I will try it. Yes it is in 2007 and doesn't happen everywhere in the sheet. Sometimes in other areas it will select 3 cells and always on a horizontal path to the right. If anyone does hear about a fix please post.

    Thanks again!
     
  4. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    Another workaround I've seen is to change the view from Page Layout to Normal. Good luck! (y)
     
  5. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,887
  6. eliztur

    eliztur Thread Starter

    Joined:
    May 5, 2010
    Messages:
    3
    Thanks everybody. This is incredible help and it is a shame that Microsoft doesn't acknowledge the problem. :)
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/921266