Enable or Disable fill handle in Excel
One can turn this option on or off by following below steps:
- Click the Microsoft Office Button
, and then click Excel Options.
- In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-dropcheck box to turn drag-and-drop editing on or off.