Cells highlight when dragging mouse : Microsoft, Excel, 2003

[jsweedler]

When I click on a cell to enter data and then move the mouse after letting go
of the button wherever the mouse goes the cells highlight, you can only close
excel by shutting it down through task manger. Basically this has rendered
all my workbook useless. Any suggestions?

 

[Tyro]

You have ClickLock turned on. Just click to turn off selecting cells.
To turn of ClickLock, Control Panel/Mouse/Buttons/ClickLock - uncheck Turn
on ClickLock

Tyro

 

[Gord Dibben]

I would hit the F8 key first to toggle out of Extended mode

If no joy with above, then not-so-gently tap on the wheel of your wheelie mouse.


Gord Dibben MS Excel MVP

 

[jsweedler]

Tried that allready, there is a setting somewhere in excel that clears this
up, I cant remember where it is.

 

[jsweedler]

No good, tried that allready

 

[Gord Dibben]

There is no setting in Excel that clears this up in versions earlier than 2007

I have no working knowledge of 2007 so will not speak for that version.


Gord Dibben MS Excel MVP

 

[jsweedler]

any other ideas as to what this could be?

 

[Tyro]

You're describing perfectly what ClickLock does. I've never seen a setting
in Excel to cause this. I currently use Excel 2007 and there is no setting
there.

Tyro

 

[Gord Dibben]

After checking the F8 key and pounding on the mouse wheel, I have nothing.

Gord