Change the color of the cursor in Excel
I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.
windows-7 microsoft-excel-2013 cursor
add a comment |
I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.
windows-7 microsoft-excel-2013 cursor
2
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34
add a comment |
I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.
windows-7 microsoft-excel-2013 cursor
I need to change the cursor color; I can hardly see mine (currently light green). I tried Themes, Color, Effects on the Page Layout tab with no success. Any ideas would be greatly appreciated.
windows-7 microsoft-excel-2013 cursor
windows-7 microsoft-excel-2013 cursor
edited Feb 25 '16 at 15:41
Burgi
3,84192542
3,84192542
asked Feb 22 '16 at 18:19
Ray
1112
1112
2
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34
add a comment |
2
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34
2
2
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34
add a comment |
1 Answer
1
active
oldest
votes
I need to change the cursor color
You can use the code ("Highlighting The Active Cell") below.
However, there is a downside:
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Source Can the Excel 'cursor' or 'cell outline' color be changed?
The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:
RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange
event of the
workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.
NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.
Source Highlighting The Active Cell
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1044108%2fchange-the-color-of-the-cursor-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I need to change the cursor color
You can use the code ("Highlighting The Active Cell") below.
However, there is a downside:
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Source Can the Excel 'cursor' or 'cell outline' color be changed?
The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:
RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange
event of the
workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.
NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.
Source Highlighting The Active Cell
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
add a comment |
I need to change the cursor color
You can use the code ("Highlighting The Active Cell") below.
However, there is a downside:
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Source Can the Excel 'cursor' or 'cell outline' color be changed?
The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:
RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange
event of the
workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.
NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.
Source Highlighting The Active Cell
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
add a comment |
I need to change the cursor color
You can use the code ("Highlighting The Active Cell") below.
However, there is a downside:
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Source Can the Excel 'cursor' or 'cell outline' color be changed?
The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:
RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange
event of the
workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.
NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.
Source Highlighting The Active Cell
I need to change the cursor color
You can use the code ("Highlighting The Active Cell") below.
However, there is a downside:
There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor - and every time a macro fires it will clear your undo stack. So, yes, it is do-able, but you'll lose your undo facility.
Source Can the Excel 'cursor' or 'cell outline' color be changed?
The RowLiner add-in (by the same author as the code below) also looks interesting. This add-in has the same issue with undo:
RowLiner will disable the Undo feature. This is a limitation imposed by the basic design of Excel and cannot be changed.
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the
following code in the Workbook_SheetSelectionChange
event of the
workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow
anytime you select a new cell, either with the mouse or with the arrow
keys.
NOTE: This technique has been greatly enhanced in my RowLiner
add-in. I strongly suggest you use RowLiner instead.
Source Highlighting The Active Cell
edited Feb 25 '16 at 21:09
answered Feb 23 '16 at 14:54
DavidPostill♦
103k25223257
103k25223257
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
add a comment |
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
At the bottom of the page for RowLiner the author states that it also disables Undo.
– Kyle
Feb 25 '16 at 21:07
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
@Kyle Well spotted. Thanks. Answer updated.
– DavidPostill♦
Feb 25 '16 at 21:08
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1044108%2fchange-the-color-of-the-cursor-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Which operating system? Which version of Excel?
– DavidPostill♦
Feb 22 '16 at 18:26
Using Excel 2013 with Windows 7
– Ray
Feb 23 '16 at 14:34