Re: Cells highlight when dragging mouse : Microsoft, Excel, 2003

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


"jsweedler" <jsweedler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
any other ideas as to what this could be?
Assistant IT Admin

"Gord Dibben" wrote:

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

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

Gord Dibben MS Excel MVP

On Tue, 26 Feb 2008 17:55:01 -0800, jsweedler
<jsweedler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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


Relevant Pages

  • Re: Selection sticks in Excel
    ... On the Buttons tab, there's a section called ClickLock, if my guess ... is correct the Turn on ClickLock selection will be ticked. ... | I teach Excel to beginning students. ... highlighting cells ...
  • Re: proper way to nest AND & OR with IF?
    ... Obviously I am missing something here, but I cant see it! ... I used to do this in 123 all the time, and I thought the proper syntax ... in excel was IF,arg3),do_this,or_this) - but that ...
  • Re: MS applications
    ... They are part of the MS Office Suite. ... > I have a new PC and cant remember if I activated my copy of XP. ... > cant find any of my MS applications - word, excel, ppt, access. ...
  • Re: hidden top row??
    ... You hide the rows first then apply Freeze Panes ... Gord Dibben MS Excel MVP ... From the Excel Main Menu: ... used uparrow, which indicated I was in cell A3, A2, A1 respectively each time ...
  • Re: Worksheet Change Event With Validation List
    ... > longer triggered by changing the cell by the Validation list. ... > has altered a setting within Excel that I am not aware of. ... so cant be the fact that I have Excel 2002. ... > Private Sub Worksheet_Change ...