How to Enable Drag Formula in Excel (With Quick Steps)

Sometimes, while working in Microsoft Excel, you may find that the drag & drop cursor or the fill handle tool is not showing up. If this occurs, you may need to enable these options.

Step 1 – Go to Options from File Tab

Open the Excel file, go to the File tab, and select Options from the bottom of the menu.

How to Enable Drag Formula in Excel

Read More: How to Use Fill Handle in Excel

Step 2 – Go to Advanced Options

A window named “Excel Options” will open.

Go to the Advanced option.

How to Enable Drag Formula in Excel

Read More: How to Drag Formula in Excel with Keyboard 

Final Step – Mark ‘Enable fill handle and cell drag-and-drop’ Checkbox

In the advanced option, go to the Editing Options.

Under the Editing Options, find the box named ‘Enable fill handle and cell drag-and-drop’ and mark them.

Mark “Enable fill handle” Checkbox


Press OK. The drag & drop option should be enabled successfully.

Read More: How to Drag Formula and Ignore Hidden Cells in Excel

Excel Drag Formula Not Working

Sometimes even after enabling the drag & drop option, it is not working and requires further troubleshooting.


  • Go to the top ribbon and select the Formulas tab.
  • Under the Formulas tab, go to the Calculations Options. 3 options will open.
  • Select the Automatic option

Excel Drag Formula Not Working


Read More: [Solved]: Fill Handle Not Working in Excel

Related Articles

<< Go Back to Fill Handle in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

  1. Thank you thank you! I followed each step listed on this article and it fixed my problem! the “automatic” button somehow got switch to manual and i had no idea! thank you! this article helped me save so much time!

Leave a reply

Advanced Excel Exercises with Solutions PDF