How to Get Rid of Plus Sign Cursor in Excel: 2 Effective Methods

Method 1 – Using Excel Advanced Option

  1. Go to the File tab.Opening the File tab
  2. Select Options from the left navigation menu.Selecting Options from Backstage View An Excel Options dialog box will appear.
  3. Select Advanced > Enable fill handle and cell drag-and-drop > OK.
    Enabling Fill Handle tool
  • Hover the mouse at the right bottom corner of a cell. You will see a black color plus sign known as the Fill Handle tool. Drag it to copy the formula.

Fill handdle tool visible

  • It worked, and here’s the result.
    Using plus sign cursor as fill handle tool

Method 2 – Applying Excel VBA

  1. Open the Developer tab and select the Visual Basic option.Opening visual basic editor A new window of Microsoft Visual Basic for Applications will appear.
  2. Go to View tab > Immediate Window.Opening Immediate window
  3. Write the following code in the window and press Enter:

Application.Cursor = xlNorthwestArrow
Code to get rid of plus sign cursorGet the white cursor changed into the conventional arrow cursor.

Arrow sign cursor


Download Practice Workbook


Frequently Asked Questions

Can I customize or change the appearance of the plus sign cursor in Excel?

Yes, you can change the appearance of the plus sign cursor by applying the VBA method of this article.

How to get rid of the plus sign cursor in Microsoft Office 2010?

You can use the same methods of this article to get rid of the plus sign cursor in Office 2010.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also interested... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo