Excel’s AutoComplete feature suggests cell entries as you type, based on existing data in the same column. This can be helpful for consistency but may also be distracting or disruptive to your workflow. The feature is controlled by a single setting in Excel’s options. This article explains how to locate and disable this setting to stop all AutoComplete suggestions.
Key Takeaways: Disabling Excel AutoComplete
- File > Options > Advanced > Enable AutoComplete for cell values: Unchecking this box turns off the main suggestion feature for all workbooks.
- Alt + F, T, A: This keyboard shortcut sequence opens the Advanced options tab directly.
- Excel Options dialog: The setting applies globally to the application, not just the current worksheet.
What the Excel AutoComplete Feature Does
AutoComplete is designed to speed up data entry. When you start typing in a cell, Excel scans the column for any entries that begin with the same characters. If a match is found, Excel suggests the complete entry. You can accept it by pressing Enter or Tab, or ignore it by continuing to type. This works for text, numbers, and dates.
The feature only looks at entries in the same column and above the active cell. It does not search rows or other worksheets. Before disabling it, ensure you have the correct workbook open, as the setting change affects all future workbooks you open in Excel. No other prerequisites are needed.
Steps to Disable AutoComplete in Excel
The setting to control AutoComplete is located in the main Excel Options menu. Follow these steps to turn it off.
- Open the Excel Options dialog
Click the File tab on the ribbon. Then select Options from the menu on the left. This opens the Excel Options window. - Navigate to the Advanced settings
In the Excel Options window, click on the Advanced category in the left-hand pane. This will display a long list of advanced editing, display, and formula options. - Find the AutoComplete setting
Scroll down the list of options until you see the section labeled Editing options. Look for the checkbox that says Enable AutoComplete for cell values. - Disable the feature
Click the checkbox to remove the checkmark. This action turns off the AutoComplete feature. Click the OK button at the bottom of the window to save the change and close the dialog.
Using a Keyboard Shortcut
You can navigate to the setting faster using keyboard shortcuts.
- Press Alt + F to open the File menu
This activates the File tab on the ribbon. - Press T to select Options
This opens the Excel Options dialog directly. - Press A to select the Advanced tab
This jumps your cursor to the Advanced options pane. - Navigate and uncheck the box
Use the Tab key to move down to the Editing options section. Use the arrow keys to find the Enable AutoComplete for cell values checkbox. Press the Spacebar to uncheck it. Press Enter to confirm and close the dialog.
Common Mistakes and Limitations
AutoComplete Still Appears After Turning It Off
If suggestions still appear, you may have only changed the setting for one workbook. The setting in File > Options is application-wide. Close and reopen Excel to ensure the change takes full effect. Also, verify you unchecked the correct box; there is a separate AutoCorrect option that does not control cell suggestions.
Feature Does Not Work With Filtered Lists or Tables
AutoComplete may not suggest entries from rows hidden by a filter. It also behaves differently within Excel Tables, sometimes referencing the table column header. Disabling the main option stops all these behaviors uniformly.
Confusion With Flash Fill
AutoComplete is not the same as Flash Fill. Flash Fill recognizes patterns in your data and fills columns automatically when you press Enter. Disabling AutoComplete does not affect Flash Fill, which has its own setting under File > Options > Advanced > Automatically Flash Fill.
AutoComplete On vs. Off: Key Differences
| Item | AutoComplete Enabled | AutoComplete Disabled |
|---|---|---|
| Data entry suggestions | Excel shows matching entries from the same column | No suggestions appear as you type |
| Keyboard acceptance | Press Enter or Tab to accept a suggestion | Every character must be typed manually |
| Speed for repetitive data | Can be faster for standardized lists | Prevents accidental selection of wrong suggestions |
| Control over input | Less control, suggestions can interrupt flow | Full manual control of every cell entry |
| Application scope | Setting applies to all workbooks by default | Setting applies to all workbooks after change |
You can now enter data in Excel without any automatic suggestions. The File > Options > Advanced path gives you full control over this behavior. For related settings, explore the AutoCorrect options to manage automatic capitalization. Remember that pressing F2 to edit a cell will not trigger AutoComplete even when the feature is on.