How to Change the Cursor Color in Excel -2 Quick Methods

 

A mouse cursor shows and a cell border cursor are showcased in the image below.

What Is a Cursor

This is the sample dataset.

Dataset to Change Cursor Color in Excel


Method 1 – Change the Cursor Color of Selected Cells Using VBA

  • Go to Developer Visual Basic to open the VBA Editor or press ALT + F11.

Change Cursor Color Of Selected Cells Using Excel VBA

  • Double-click the sheet name.

  • Select Worksheet from the drop-down menu.

Change Cursor Color Of Selected Cells Using Excel VBA

By selecting Worksheet the following two lines of code are generated.

Private Sub Worksheet_SelectionChange(ByVal mrTarget As Range)

End Sub

Change Cursor Color Of Selected Cells Using Excel VBA

  • Enter the following between the two generated lines.
 Cells.Borders.ColorIndex = xlNone
    Target.Borders.Color = vbRed

In this VBA code, “mrTarget.Borders.Color = vbRed” changes the selected cells’ cursor color from black to Red.  You can choose other colors.

  •  Save the code.

Select a range of cells in your Excel sheet.  The color of the active cells’ border changed from Black to Red.


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

  •  Go to the File menu.

  • Select Options.

 

  • Select Advanced.
  • Go to ‘Display option for this worksheet’.
  • Check ‘Show gridlines’.
  • In ‘Gridline Color’, choose a color. Orange, here.
  • Click OK.

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

The color of the gridlines changed to orange.


Download Practice Workbook

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


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
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