Forum Discussion

Copper Contributor

Apr 10, 2023

autocomplete stopped working after update

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 ca...

Gold Contributor

Apr 12, 2023

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!

Copper Contributor

Jul 08, 2023

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!

NikolinoDE
Gold Contributor
Jul 09, 2023
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:
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.
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.
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.
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.
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.

Resources