Sticking selections

[merize]

We have been seeing, randomly of course, when you click in a cell it
will not let go and as you move the pointer around it will highlight the
cell your moving over. Just like if you were to click and hold and move
over multiple cells.

Anyone know why and/or how to get it to stop. The standard ESC, clicking
off somewhere, other key combos are not working.

Thanks

 

[Don Guillett]

try the f8 key

 

[Gord Dibben]

A common cause of this is that you are in "Extended" or "Add" mode.

If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple
of times.

F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you
in "ADD" mode.

With the "ADD" mode you need to re-click the mouse. This is used to select
non-contiguous cells and ranges without using the CTRL key.

With the "EXT" mode you just click once and drag. All cells will be selected.

If you are using a wheel-mouse tap the wheel a couple times.

Also see David McRitchie's "Ghosting" at

http://www.mvps.org/dmcritchie/excel/ghosting.txt


Gord Dibben Excel MVP