Mouse pointer problem

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
All on a sudden my mouse pointer in excel is not working properly. I cannot use my mouse to drag and fill, or to adjust the page break lines in the Page Break View mode. It always is in the shape of the white cross with black border and never changes it shape when pointed at the lower right edge of cells too. Now.......what to do in order to get out of this problem.
TIA
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
It was noticed that any selected cell NOW has a full border for it....whereas actually it is a border with a "dot" on the lower right hand corner earlier.
Any guesses....?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
39,795
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Which version of Excel. I suspect cell drag and drop had been turned off but the details of how to reset it vary.
 

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Thanks A Lot. Your diagnosis was perfect. That itself was the problem.
I use Excel 2003 with Windows XP.....(if that will provide more ways to get out of this problem).
Thanks A Lot.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
39,795
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
The setting is Tools-Options, Edit tab, check the 'Allow cell drag and drop' option.
 

zatmum

New Member
Joined
Sep 28, 2011
Messages
2
My mouse pointer in excel 2007 is not working properly. I cannot use my mouse to drag and fill, or to adjust the page break lines in the Page Break View mode. It always is in the shape of the white cross with black border and never changes it shape when pointed at the lower right edge of cells too. Now.......what to do in order to get out of this problem.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
39,795
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
In 2007, it's in Excel Options (click the Office button) in the Advanced section, third option is: 'Enable fill handle and cell rag-and-drop'. Check that.
 

zatmum

New Member
Joined
Sep 28, 2011
Messages
2
Thank you very much. This very useful and i have sorted out my problem. One another problem, i am also facing in excel 2007 that is i cannot edit cell contains directly by double clicking at particular cell by mouse, which i want to edit. Please help me for this problem.
Thanks again.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
39,795
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
That's the allow edit in cell option below the other one. :)
 

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top