fbpx

Sometimes I found that drag option is not working in the which is essential to replicate the formula on all the cell in one go. By default, drag-and-drop editing is turned on so that you can drag the pointer to move and copy text. This option can be turned off.

How to Enable Drag and Drop Option in Microsoft Excel
The user can enable or disable this feature in the excel as per their requirement however it is a very essential feature to replicate the formula in all the desired cells. It is not possible without enabling this feature in the Microsoft .

How to Enable Drag and Drop Option in Microsoft Excel

How to Enable Drag and Drop Option in Microsoft Excel

Microsoft Excel 2007, 2010, 2013, 2016

  1. Click the Microsoft Office Button which is visible in the top left corner and then click Excel Options.
  2. Click Advanced.
  3. Under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.
    How to Enable Drag and Drop Option in Microsoft Excel How to Enable Drag and Drop Option in Microsoft Excel
    After enabling this feature, you can copy the formula from one cell to another. We have taken the screenshot of Microsoft Excel 2007 but a user can enable or disable this feature in all version of Microsoft Excel i.e. 2010, 2013, 2016.

Leave a Reply

0 Shares
Share
Tweet
Share
+1
Pin