How to enable fill handle/formula drag-and-drop handle in Ms Excel
Fill handle tool of Excel helps in applying a formula of current cell to other cells just by dragging. Some time because of some grinch this fill handle doesn’t show up. The following steps will help you bring back the fill handle in Excel.
Steps to show/enable fill handle and cell drag-and-drop
Steps for Excel 2010 and above
- Go to Files > Options
- In “Advance” Category, under “Editing Options”, check box against “Enable fill handle and cell drag-and-drop” and click ok.