How to Change Cursor Color in Excel (2 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

A cursor helps us identify the current active region on a computer screen. But if the cursor color is identical to that of the theme color or the background color, it might be quite hard to separately recognize the cursor. Thus, changing the cursor color becomes obvious by then. In this article, I will show you how can you change the cursor color in Excel with ease.


What Is a Cursor?

A cursor is an indicator on a display that helps to recognize the current active region controlled by an input device.

In Excel, you will see two types of cursor mainly. The first one is a mouse cursor. This mouse cursor shows where you are pointing currently using the mouse. The second one is the cell border cursor. This shows which cell or which cell range is currently active.

What Is a Cursor


How to Change Cursor Color in Excel: 2 Quick Methods

I will be using the following Sales Report to show you how to change the cursor color in Excel.

Dataset to Change Cursor Color in Excel


1. Change the Cursor Color of Selected Cells Using VBA

It’s really frustrating that Excel doesn’t have any built-in feature to change the cursor color of the active cell or the selected cells.

The default cursor color of the active cell border is Green. Sadly there’s no option to change this default active single-cell border color.

However, you can change the cursor color of the selected cell range using a VBA code.

Now I’m going to show you how to change the cursor color of the selected cells in Excel using VBA.

❶ First of all, go to Developer Visual Basic to open the VBA Editor.

If you don’t have the Developer tab, you can press ALT + F11 to open the VBA Editor.

Change Cursor Color Of Selected Cells Using Excel VBA

❷ After that double-click on the Excel sheet name that you want to prompt for the changes of the selected cell cursor color.

❸ After that, select Worksheet from the drop-down menu across the General option.

Change Cursor Color Of Selected Cells Using Excel VBA

When you select Worksheet instead of General, the following two lines of code generate instantly.

Private Sub Worksheet_SelectionChange(ByVal mrTarget As Range)

End Sub

Change Cursor Color Of Selected Cells Using Excel VBA

❹ Now insert the following two lines in the VBA Editor between the two lines generated automatically.

 Cells.Borders.ColorIndex = xlNone
    Target.Borders.Color = vbRed

In this VBA code, the line “mrTarget.Borders.Color = vbRed” changes the selected cells’ cursor color from black to Red. For your kind information, the default cursor color of the selected cells is Black. But this VBA code changes the cursor color from Black to Red. You can choose other colors as per your choice. You just need to edit the target border color. That’s it.

❺ Anyways, after inserting the code, save it.

Now come back to your Excel sheet. Select a range of cells. You will see that the active cells’ border color has changed from Black to Red.

Here’s I’ve attached a screenshot of my dataset being selected. You can see that the cursor color is red here.


2. Advanced Options to Change Cursor Color of Active/Inactive Cell

This method changes the cursor color of all cell borders. Another way to say that it changes the cell grid colors regardless of the cells being selected or inactive.

❶ At first, you need to go to the File menu.

❷ Then select Options.

The Excel Options dialog box will appear.

❸ Now select Advanced from the left-most column.

❹ After that go to the ‘Display option for this worksheet’ section.

❺ Check ‘Show gridlines’.

❻ Then select a gridline color beside the ‘Gridline Color’ option.

I’m selecting an Orange color here.

❼ After that press the OK button.

Using Advanced Options to Change Cursor Color Of Active/Inactive Cell

Now you will see that the cursor color of the gridlines has changed to orange. The default color of the gridlines is black. But the color is now changed to orange.


Things to Remember

  • The VBA method changes the cursor color of only the sheet where you’ve embedded the VBA It doesn’t affect the other Excel sheets.
  • If ALT + F11 doesn’t open the VBA Editor, then try ALT + Fn + F11. I Hope, this might work this time.

Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

To sum up, we have discussed 2 methods to change cursor color in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP.


Related Articles


<< Go Back to Cursor in Excel | Excel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo