Disabling the AutoFill Feature

The AutoFill feature of Excel is a great timesaver when you need to fill in a series of cells based on the content in other cells. It is also a feature that you can turn off, if you prefer. (For instance, the AutoFill handle visible at the bottom-right corner of a selection may be distracting to you, and you want to turn it off.)

To turn off AutoFill, follow these steps:

1. Click the Office button, then click Excel Options. Excel displays the Excel Options dialog box.
2. Click the Advanced option at the left of the dialog box. (Click here to see a related figure.)
3. In the Editing Options area, clear the Enable Fill Handle and Cell Drag-and-Drop check box.
4. Click on OK.

Besides turning off AutoFill, the above steps also turn off the ability to drag the contents of a cell from one location to another.