Uncheck "Enable Auto Complete for Cell Values" to stop Excel from trying to complete what you type based on existing cell entries that begin with the same characters. Uncheck "Enable Fill Handle and Cell Drag-and-Drop" to turn off the fill handle.With this preference deactivated, you cannot drag from the lower-right corner of a cell to populate adjacent cells with consecutive or related values. Locate the Excel Option's dialog box Cut, Copy and Paste section.
I created this with the latest version of Camtasia Studio, which has a new feature that captures keyboard shortcuts, and can show the key combinations in the video.
Uncheck the "Show Paste Options Button When Content Is Pasted" option to turn off the Auto Fill Options button that appears when you drag the fill handle.
With this option deactivated, you won't see the Auto Fill Options button that usually appears at the lower right corner of the last cell you fill.
If you’re entering dates on an Excel worksheet, and there’s data in the adjacent column, you can use the Fill handle to make the job quick and easy.
Enter the first date in the date column, then point to the Fill handle, and double-click.