Cells highlight when dragging mouse : Microsoft, Excel, 2003


J

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?
 
Ad

Advertisements

T

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
 
G

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
 
J

jsweedler

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

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
 
Ad

Advertisements

T

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
 
Ad

Advertisements

G

Gord Dibben

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

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top