Forum Discussion
autocomplete stopped working after update
One thing you could try is to check if the “Enable AutoComplete for cell values” option is turned on. To do this, go to the File tab in Excel and click on Options.
In the Excel Options dialog box, go to the Advanced tab and scroll down to the Editing options section. Make sure that the “Enable AutoComplete for cell values” option is checked.
If this option is already checked and you’re still having trouble with autocomplete, you could try repairing your Office installation.
To do this, go to the Control Panel and click on Programs and Features.
Find your Office 365 installation in the list of programs and click on Change.
In the dialog box that appears, select Quick Repair and follow the prompts to repair your Office installation.
I hope this helps!
BenTheWicked I had the same problem for weeks, and I don't know exactly which step fixed it, but here's what I tried this morning and now it's working!
1) duplicate the sheet (within the workbook)
2) insert a blank row above the content you're working on/below the headers
3) test autocomplete, and see that it's working on the duplicated sheet
4) delete the duplicate sheet so that I'm back to the original sheet
5) insert the blank row again, below the headers and above the content
6) test and see that autocomplete is working again
7) delete the blank row
😎 now it seems fixed!The reason I tried this is because my workbook has several sheets, and autocomplete was working as expected on the other sheets but was not working as intended (same as you described) on the first sheet. The issue only came up in the web browser version -- when I switched to the desktop version of excel (to double check settings) it was working without issue, so that didn't seem to provide a path to resolution. I also read elsewhere (while I was trying to diagnose the issue) that autocomplete only works for contiguous (no gaps) cells, so I figured if it's able to autocomplete the headers but not the content, maybe I just need to break the headers away from the content so they're no longer contiguous, that might force autocomplete to sort itself out.
I'm not sure exactly which part of my troubleshooting steps fixed it, but it's fixed for me now in the web browser version on the sheet that was causing troubles. Best of luck to future readers who come across the same issue, I hope this works for you too!
Late to the party, but same issue in an O365 shared spreadsheet with customized views that used to have working auto-complete, it seemed to randomly stop working.
Tried clearing caches, different browsers, duplicating sheets, inserting rows, removing capitalizations from headers, etc.
Apparently the "randomly" was me enabling freeze panes.
Solution for me was disabling Freeze Panes (View > Freeze Panes > . Removed Freeze Panes and auto-complete started recognizing non-header cells again.
Tried reenabling Freeze Panes via both Freeze Top Row and Freeze Panes and the functionality broke again both times.
Hope this helps someone.
Dan_L2265 I am using excel in Teams and this also worked for me. Autocomplete will not work if I freeze panes.
