Forum Discussion
Autocomplete text in Excel
Turn automatic completion of cell entries on or off
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.
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
- NikolinoDESep 06, 2022Platinum Contributor
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
- Giles_PSep 06, 2022Copper ContributorI'm using Excel in a paid subscription Office 365, bought a month ago, on an ASUS Chromebook
- NikolinoDESep 06, 2022Platinum Contributor
I can't help you with Chromebooks, I'm not familiar with them.
The only information I could find is in the link below.
Thank you for your patience and understanding