How to Disable a Date Autofill in Excel

Disable the AutoComplete Option
1. Open the Excel file.
2. Click the 'File' tab on the command ribbon. A list of basic commands appears.
3. Click 'Options.' The 'Excel Options' window appears. The left pane includes the 'Advanced' command.
4. Click 'Advanced.' A list of editing options appears.
5. Clear the check box for 'Enable AutoComplete for cell values.'
6. Click 'OK.' This button is located at the bottom of the dialog window. The 'AutoComplete' command no longer copies the cell data to new cells. The worksheet is open for editing.
Disable the AutoFill Option
7. Open the Excel file.
8. Click the 'File' tab on the command ribbon.
9. Click 'Options.' A list of basic commands appears.
10. Click 'Advanced.' A list of editing options appears.
11. Clear the check box for 'Enable fill handle and cell drag-and-drop.'
12. Select the check box for 'Alert before overwriting cells.' This text may appear faint.
13. Click 'OK.' The worksheet opens. The fill handle does not activate in the corner of the cell.