Forum Discussion
Autocomplete text in Excel
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.
Turn automatic completion of cell entries on or off
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010Microsoft 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.
Click File > Options.
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
