Intermittant problem

  • Thread starter Thread starter BoomerD
  • Start date Start date
B

BoomerD

In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)
 
Hi,

I don't think you want F11 - that is Insert Chart.

You can cancel Extend mode with either F8 or Esc
 
Always vertical, not horizontal certainly rules out being in Extended mode
as others have suggested.

If using Excel 2007 it has been reported that changing the Zoom level a bit
will stop the multi-cell selection.


Gord Dibben MS Excel MVP
 
Thanks for the suggestions.

I'll check this out later and report back.

As you can imagine, it makes working with functions and such...awkward at
best.


FWIW, this happens when using a mouse click, not keyboard to select cells.
 
If only with mouse, it's definitely not the F8 Extended mode problem.

In Extended mode, moving with the arrow keys also selects cells.

That should narrow it down.


Gord
 
Gord Dibben said:
Always vertical, not horizontal certainly rules out being in Extended mode
as others have suggested.

If using Excel 2007 it has been reported that changing the Zoom level a bit
will stop the multi-cell selection.
Click to expand...


Now THIS is odd.
At 80%, it selects 2 cells.
At 90% it selects 3 cells.
At 100 and 110% it selects 4 cells.
At 120%, it only selects 1 cell.

What the heck causes this?
It doesn't happen in all spreadsheets, but once it happens in one, it ALWAYS
happens in that sheet, and in the same place.(s)
 
A quick correction.
At 110%, it highlights 5 cells...

Unfortunately, my eyes won't let me work at much less than 80%, and more
than 120% gets unwieldy.
 
I don't know the cause and haven't worked with 2007 long enough to see the
problem arise.

No idea where to go from here.

Anybody?


Gord
 
Back
Top