Intermittant problem

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

 

[Mike H]

Hi,

You may be accidentally tapping F8. Tap it again when this happens.

Mike

 

[Shane Devenshire]

Hi,

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

You can cancel Extend mode with either F8 or Esc

 

[Gord Dibben]

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

 

[BoomerD]

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.

 

[Gord Dibben]

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

 

[BoomerD]

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.

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)

 

[BoomerD]

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.

 

[Gord Dibben]

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