Sep 05 2022 08:39 AM
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.
Sep 05 2022 11:12 PM
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)
Sep 06 2022 01:57 AM
@NikolinoDE Thank you for your reply but there is no Advanced under Options on my version of Excel, Officec365 2021
Sep 06 2022 02:07 AM
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
Sep 06 2022 02:47 AM
Sep 06 2022 02:56 AM - edited Sep 06 2022 02:57 AM
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