Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

If you want to get rid of plus sign cursor in Excel, you have come to the right place. In this article, we will walk you through 2 easy and effective methods that will help you to do the task effortlessly.

Download Practice Workbook


2 Methods to Ged Rid of Plus Sign Cursor in Excel

The following Get Rid of Plus Sign Cursor table contains Item, Price, Discount, and New Price columns. In cell E5 we calculate the New Price by a formula shown on the Formula Bar. Now, we want to drag the formula down with the Fill Handle tool. However, we can see that when we click on cell E5, a white plus sign appears instead of the Fill Handle tool.

In this article, we will discuss how to get rid of plus sign cursor in Excel. Here, we used Excel 365. You can use any available Excel version.

How to Get Rid of Plus Sign in Excel


Method-1: Using Excel Advanced Option to Get Rid of Plus Sign Cursor

Here, we will use the Advanced Excel option to get rid of plus sign in Excel.

Steps:

  • First, we will go to the File tab.

  • Afterward, we will select Options.

An Excel Options dialog box will appear.

  • Then, we will select Advanced > we will mark Enable fill handle and cell drag-and-drop box
  • Finally, click OK.

How to Get Rid of Plus Sign in Excel

  • Next, we will click on cell E5 and hover the mouse at the right bottom corner of the cell.

We will see a black color plus sign which is known as the Fill Handle tool.

  • Afterward, we will drag down the formula from cell E5 with this Fill Handle tool.

Finally, we can see the complete New Price column.

How to Get Rid of Plus Sign in Excel

Read More: How to Unlock Cells in Excel When Scrolling (4 Easy Ways)


Similar Readings


Method-2: Changing Cursor Positions to Get Rid of Plus Sign

In this method, we will describe 3 examples where you will see how we get rid of plus sign in Excel.

2.1. Changing Cursor Position

  • First, when we click on cell E5, we can see a white plus sign.

  • Afterward, we will move the mouse cursor to the right border, and we can see a black 4-sided arrow sign, which is used to drag the cell content to a different cell.

Here, we will see the black 4-sided arrow sign if we hover our mouse cursor on any of the borders.

How to Get Rid of Plus Sign in Excel

  • After that, we will click and hold the mouse and we will move to cell G5.

We can see the movement of the cell in the following picture.

  • Then, we will release the mouse cursor.

Finally, we can see the value of cell E5 is shifted to cell G5.

Read More: [Fixed!] Excel Arrows Scrolling Not Moving Cells (6 Possible Solutions)

2.2. Hovering in Ribbon

In this example, we can see that if we hover our mouse cursor on the tabs, the plus sign gets replaced with the mouse cursor sign.

2.3. Using Formula Bar

Here, we can see that when we click on cell E5, a white plus sign appears. Additionally, we can see that there is no sign in the Formula Bar.

  • After that, if we double-click on cell E5, we will see there is no white plus sign in cell E5.
  • Along with that, if we hover our mouse on the Formula Bar, we will see an I shape sign.

How to Get Rid of Plus Sign in Excel

Read More: Smooth Scrolling with Mouse Wheel in Excel (A Detailed Analysis)


Conclusion

Here, we tried to show you 2 methods to get rid of plus sign cursor in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website ExcelDemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo