Autocomplete has stopped working

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.