Enable or Disable fill handle in Excel

Enable or Disable fill handle in Excel

One can turn this option on or off by following below steps:

1. Click the Microsoft Office Button , and then click Excel Options.

2. 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.