Disable autocomplete suggestion feature in Excel

Excel Auto Complete features automatically suggests a value based on previous entries. Similar to disabling auto fill feature, Excel provides option for disabling the autocomplete suggestion feature as well. So you turn off auto complete suggestion feature if you find it distracting.

Auto complete suggestion in Excel 2010 and Excel 2013

Listed below are the steps to disable autocomplete suggestion in Excel 2016, Excel 2013 and Excel 2010.

Step 1: To disable autocomplete suggestion feature in Excel, click the File menu and then Options to launch the Excel Option window.

Step 2: Select Advanced tab and navigate to editing Options.

Enable Auto Complete for Cell Values in Excel 2010 and Excel 2013

Step 3: Under Editing options, un mark the check box with label as Enable Autocomplete for cell values

Step 4: Click OK button to confirm and save the changes.

Also See: Turn off auto complete suggestion in Outlook

In Category: Excel 2010, Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 1 Comment

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.