autocomplete stopped working after update

Copper Contributor

Office 365 just updated. Now, autocomplete only works for some columns. So if I'm in column A, and typing the exact same text from the cell directly above, the text will suggest autocomplete and I can hit enter and move on. However, in column B, exact same text is never given autocomplete option. If I copy any cell from column A and paste in column B, that cell will now autocomplete. However if I copy and paste only formatting, the new cell will not autocomplete. None of this was an issue until the auto update that happened today after I restarted. Also, this issue is only in existing workbooks.  If I create a new workbook, a cells seem to be fine in terms of autocomplete.

8 Replies

@salalalazar 

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!

I'm using Office Online, and the only option I have in the Options section is Regional Format Settings. Also, my Excel is able to autofill the top row, but it does not seem to see or recognize any other row. It started only autofilling the top row about an hour into my project, so it was previously working correctly. I closed the sheet and reopened it, but it still only fills the top row. Is there another way to turn autofill back on or adjust it to recognize the rest of my sheet?
I've tried all steps including quick repair but my autocomplete still doesn't work. Excel, please help, after all i am paying monthly fees for your services!

@Babikina 

In Office Online (Which hasn't been mentioned before), the options and settings available are limited compared to the desktop version of Excel. AutoFill behavior in Office Online can sometimes be affected by browser settings or temporary issues. Here are a few suggestions to try:

  1. Clear browser cache: Clearing the cache in your browser can help resolve temporary issues. Go to your browser's settings or options, find the option to clear cache or browsing data, and clear it. Restart your browser afterward.
  2. Try a different browser: If you are using Office Online in one browser, try opening it in a different browser to see if the issue persists. Sometimes, browser-specific issues can affect certain functionalities.
  3. Check browser settings: Ensure that your browser settings allow for autofill or autocomplete functionality. Some browsers have specific settings related to autofill or form completion. Make sure those settings are enabled.
  4. Check for browser extensions: Disable any browser extensions or plugins that may interfere with the autofill functionality. Extensions related to form filling or data entry can sometimes cause conflicts.
  5. Restart your computer: Restarting your computer can help clear any temporary issues and refresh the browser's state.

The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

@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
8) 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.

@salalalazar after dragging the auto fill options will open in that select fill series

@salalalazar 

I'm using the desktop app. Autofill is prevented if you are using data filtering to hides rows. This is true even if you are below the hidden rows. (Ask me how I know ;-).  Microsoft: this may be new mis-behavior.