Picking one cell will highlight four or five, Excel 2007

[Jen]

At first I thought it may be a mouse problem; but today, with two different
worksheet open side-by-side, this would happen in one worksheet but not the
other. I try to pick just one cell, but the cell I pick plus the four or
five cells below it get highlighted. It makes copying & pasting all but
impossible. The problem is intermittent too, it starts and stops with
seemingly no reason. Has anyone else experienced this?

Excel 2007, Win XP SP2

 

[Jen]

I've encountered the "anchored selection" before and that's not quite what's
happening here. No matter where I pick, the cell I pick plus the ones below
are highlighted. Hitting esc doesn't help, I've tried. It often stops as
abruptly as it begins without any rhyme or reason. Totally wierd.

 

[Gord Dibben]

Try setting your Zoom level a little higher or lower to stop the
multi-selects.


Gord Dibben MS Excel MVP