This article explains how to turn on or off the AutoComplete option in Microsoft Excel, which automatically fills in data as you type. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007, and 2003.

The steps for enabling or disabling AutoFill in Microsoft Excel differ depending on the version you are using:

Go to the File > Options menu.

In the Excel Options window, open Advanced on the left.