Can the default Cursor in 2016 be change back to an Arrow?

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153
I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow.
Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets.

Thanks in advance if you come up with this answer!

Regards,
U.S. :cool:
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153
Last edited:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,540
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
I think it can only be enforced by VBA
Try this for the Nw arrow

Code:
Sub ChangeCursor()
  Application.Cursor = xlNorthwestArrow
 End Sub

Otherwise it needs to be done via control panel and that will affect ALL applications
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153

ADVERTISEMENT

I think it can only be enforced by VBA
Try this for the Nw arrow

Code:
Sub ChangeCursor()
  Application.Cursor = xlNorthwestArrow
 End Sub

Otherwise it needs to be done via control panel and that will affect ALL applications

Thank You but that does not work for me as well. You would think they would make this a simple option to do. It can't be that hard can it? It must be cuz I can't find the answer anywhere. All I wanna do is just have an arrow cursor as a default!!!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,540
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
you have tried changing it in the Control Panel, haven't you ??
Control Panel>>Mouse>>Pointer tab>>change to suit.

Obviously it is (that hard) !!
Do you have the Developer tab on you Excel 2016 ?
If so select that tab>>Click on Visual Basic>>Dbl click "This workbook" in the LH window
Paste the code I provided in the RH pane where the cursor is flashung>>In the toolbar press the "run" arrow
Cursor should now be NW arrow
 
Last edited:

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153

ADVERTISEMENT

Thanks Mike ...

I always have my NW arrow except when I'm in Excel. I tried what you said and I just can't seem to make it work.
Your help has been much appreciated!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,540
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
OK....the obvious eluded me !!!
File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
If that don't work....I'm off to the bar !!!
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
153
OK....the obvious eluded me !!!
File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
If that don't work....I'm off to the bar !!!
I did that plus it was checked already anyways. But again Thanks!

Hey have one .. no, no make it two for me while yur at it! Heh-Heh :cool:
 

Forum statistics

Threads
1,136,444
Messages
5,675,897
Members
419,591
Latest member
mersanko

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