[MichaelAdams1993]

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!

[sro]

Is there any Merged cell formatting involved (by accident?) Is your scroll lock on by chance?

[MichaelAdams1993]

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.

[Rollin_Again]

Press your F8 key to turn off cell extension.

Rollin

[sro]

Tried a different mouse? Or mouse instead of a touch pad. Could be either of those being hyper sensitive

[MichaelAdams1993]

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.

[WendyM]

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%).

[MichaelAdams1993]

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?

[WendyM]

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.

[Keebellah]

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)

[Triple6]

Threads merged, please do not start a new thread that continues on from your previous/existing thread; continue here.