Autocomplete text in Excel

New Contributor

How do I turn on Autocomplete Text in Excel? I cannot find 'Advanced' under Options or a Preference tab in the Office version I'm using.


5 Replies


Turn automatic completion of cell entries on or off

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010

Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off.

  1. Click File > Options.

  2. Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.


I know I don't know anything (Socrates)

@NikolinoDE Thank you for your reply but there is no Advanced under Options on my version of Excel, Officec365 2021


The information of the exact Excel version and operating system would be an advantage to better understand the cause.



Thank you for your patience and understanding


I'm using Excel in a paid subscription Office 365, bought a month ago, on an ASUS Chromebook


I can't help you with Chromebooks, I'm not familiar with them.

The only information I could find is in the link below.

Excel Auto Fill Function


Thank you for your patience and understanding