Forum Discussion
Autocomplete has stopped working
I'm using the Office 365 (web version) of Excel to keep track of my paper trades. Until recently, I was able to populate the ticker name and symbol columns with previous entries by just starting to type their name. It would then "autosuggest" based on those previous ticker names/columns. Now, it doesn't do it anymore. I've tried to find a solution online but they often reference menu items that don't even exist.
How do I fix this? I can always copy and paste but it's so much easier and convenient to be able to use this auto complete feature to populate with pre-existing entries.
1 Reply
Excel for the Web does not currently support the familiar AutoComplete for cell entries that works in the desktop version…so far I know.
Workarounds you can try
Use Data Validation Dropdowns
1. Make a list of your tickers
- For example, in a hidden sheet or off to the side:
- AAPL
- MSFT
- AMZN
- GOOG
- TSLA
2. Select the column where you want to enter tickers.
3. Go to Data → Data Validation.
4. Under Allow, choose List.
5. For Source, select the range with your tickers (e.g., =$Z$1:$Z$100).
6. Click OK.
Now, when you type in that column:
You’ll see a dropdown arrow.
Start typing a ticker → the dropdown filters the list to match what you typed.
(This works in Excel for Web and is the closest thing to AutoComplete.).Or… Use Desktop Excel to Configure Workbook and Sync to OneDrive.
My answers are voluntary and without guarantee!
Hope this will help you.
