Autocomplete is a helpful setting in a number of different programs where you might be repeatedly entering the same word. Autocomplete works by recognizing the first few letters that you have typed, seeing that a similar word already exists in the document, then offering that word to you in the form of a blue-highlighted suggestion. If you press Enter on your keyboard when the autocompletion is presented, Sheets will add that word to the cell without requiring you to type the rest of it.
While this is helpful sometimes, you may find that it is causing you problems. Fortunately autocomplete can be disabled in Google sheets by completing the steps below.
How to Stop Autocomplete in Google Sheets
The steps in this article are going to prevent Google Sheets from giving you an autocomplete option when you are typing data. By this we mean the text highlighted in blue that occurs when you start typing a word that is already in the sheet. For example, in the image below, Sheets is giving me an autocomplete option for the word September when I type the first few letters of the word.
Turning off the autocomplete option will prevent that from occurring.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and double-click the spreadsheet for which you would like to disable autocomplete.
Step 2: Click the Tools tab at the top of the window.
Step 3: Click the Enable autocomplete option to remove the check mark.
Now when you start typing a word that already exists in Google Sheets it won’t give you the option to press Enter on your keyboard and add that word. Autocomplete has been disabled in the picture below.
If you’re used to merging cells in Excel, but are having trouble finding that option in Sheets, then learn how to merge cells with Google Sheets so that you can get the same effect in Google’s app.
Do you need to simultaneously change the width of multiple columns in Google Sheets, but you’re having trouble getting it to work? This guide will show you how to make it happen.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.