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.

Multiple Cells in Excel

Discussion in 'Business Applications' started by MichaelAdams1993, Jan 16, 2012.

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

    MichaelAdams1993 Thread Starter

    Joined:
    Aug 22, 2009
    Messages:
    74
    I have a recurring problem when using Microsoft Excel. When I click on one cell in the worksheet in automatically selects the one or two cells next to it. No matter where I click I will not allow me to select one singe cell. This makes it twice as difficult to use formulas because it selects extra cells when doing so.

    Anyone have any ideas as to what is causing the multiple selection?

    All ideas welcome!
     
  2. sro

    sro

    Joined:
    Jan 4, 2003
    Messages:
    73
    Is there any Merged cell formatting involved (by accident?) Is your scroll lock on by chance?
     
  3. MichaelAdams1993

    MichaelAdams1993 Thread Starter

    Joined:
    Aug 22, 2009
    Messages:
    74
    No, no cell merging has taken place. It doesn't even happen to particular cells, no matter where I click in the workbook 2 or more cells are selected.
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    Press your F8 key to turn off cell extension.

    Rollin
     
  5. sro

    sro

    Joined:
    Jan 4, 2003
    Messages:
    73
    Tried a different mouse? Or mouse instead of a touch pad. Could be either of those being hyper sensitive
     
  6. MichaelAdams1993

    MichaelAdams1993 Thread Starter

    Joined:
    Aug 22, 2009
    Messages:
    74
    I posted question yesterday about having an issue with selecting a single cell in Excel, however after looking at it more today I discovered something interesting.

    When selecting cells the spreadsheet acts as you would expect a touch screen to if the calibration wasn't quite set right. For example, when I click on a cell towards its left side then that cell and the cell next to it is selected. However, if I click on the right side of the cell, then only that cell is selected. It is the strangest error I have ever experienced and I wonder if anyone has any solutions as to what caused it or what I can do to alleviate the problem. It only happens on that sheet, if I go to sheet 2 or 3 in that workbook then I don't have any issues...idea?

    Thanks in advance.
     
  7. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    What version of Excel are you using?

    If F8 doesn't work, here are a couple of other options:

    • Are you using Page Layout view? If so, try switching to Normal view.
    • Try changing your zoom magnification slightly (for example, from 110% to 100%).
     
  8. MichaelAdams1993

    MichaelAdams1993 Thread Starter

    Joined:
    Aug 22, 2009
    Messages:
    74
    Wendy: Changing the layout worked, it doesn't act that way when it's in normal view, but why does it act that way to begin with? My other sheets in the workbook don't act that way so why does this one? I would prefer for this particular document to keep it in page view so how do I make it work properly? Is there a fix?
     
  9. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    I've looked into this issue several times, and I've never seen an actual fix or any acknowledgement from Microsoft that it's a bug. Did you also try the zoom? Sometimes if you change the zoom and then change it back, it will fix the problem permanently for that workbook. It does seem to be worksheet-specific, so it doesn't surprise me that it only happens on one page. Sorry I don't have a better solution.
     
  10. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    5,949
    I've no idea but it looks like that sheet is protected in some way, have you checked that?

    Another thing I advice, inlcude the version of Excel you're, it could be options which are not present in 2003 or older but are present in newer versions.

    The more complete your information is the better answers you'll get. (and maybe faster)
     
  11. Triple6

    Triple6 Rob Moderator

    Joined:
    Dec 26, 2002
    Messages:
    45,606
    Threads merged, please do not start a new thread that continues on from your previous/existing thread; continue here.
     
  12. 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/1036587