Spell check is used more with word processors such as Google Docs or MS Word or with presentation tools such as Google Slides or PowerPoint.
But what about a Google Sheets spell check function?
While Google Sheets is more about data entry, record keeping, and data analysis, you may still need to run spell check for Google Sheets in it from time to time.
A lot of people also use Google Sheets with a lot of text data. And in such cases, Google spreadsheet spell check is a must to ensure there aren’t any spelling errors, especially if it is an official document.
Unfortunately, unlike Google Docs, which highlights misspelled words with a red underline, there is no visual indication when there are misspelled words in Google Sheets.
But you can easily run spell check in Google Sheets, and in this tutorial, I will show you how to use spell check in Google Sheets.
So let’s get started!
Table of Contents
How to Spell Check on Google Sheets
For spell check to work in Google Sheets, you need to select all the cells where you want to check for misspelled words. This could be a specific range of cells or the entire sheet. Let’s take a look at how to spell check Google Sheets.
Suppose you have a list of items as shown below, and you want to use spell check on this data:
Below are the steps to run spell-check on this data:
- Select the data on which you want to run spell check
- Click the Tools option in the menu
- Click on Spelling
- Click on ‘Spell check’
The above steps will run the spell check in Google Sheets, and you will see it open as a separate dialog box in the top right part of the sheet. In the dialog box, the spell check tool will give you one or more suggested spelling options for the spelling errors it finds. This will of course, depend on the language that Google Sheets is set to. However, the spell check tool won’t mark words in British as spelling errors if you’re using American English. But if you write a spelling error, it will give you the spelling for the default language.
Google Sheets Spell Check Shortcut for Keyboards
Although there is no way to add the spell check option to the toolbar in Google Sheets, thankfully, there is a keyboard shortcut you can use to run spell-check.
But before you can use the keyboard shortcut, you need to enable one small setting – enable compatible shortcuts option (one-time thing):
Below are the steps to enable compatible shortcuts and how to turn on spell check in Google Sheets with them
- Click the Help option in the menu
- Click on the Keyboard shortcuts option
- In the Keyboard Shortcuts dialog box that opens, enable the ‘Enable compatible spreadsheet shortcuts‘ option.
Once you have done this, you can use the keyboard shortcut F7 to run spell-check in Google Sheets:
Understanding Spell Check on Google Sheets – Options
When you run a spell check in Google Sheets, you have a couple of options:
You can change ṭhe misspelled word with the suggestion. If the suggestion is incorrect, you can also enter the correct spelling. You can also do this for each cell one by one or apply this change all in one go.
If the spell check has highlighted something which is not a misspelled word, you can ignore it. You can also choose the ‘Ignore all’ option to ignore all the instances of this word.
When you choose to ignore, it usually applies to the entire sheet or the whole selection. If you choose ignore by accident, one way to remove it is to clear the caches for Google docs in your browser settings.
Add to Dictionary
If spell check highlights a correct word and you plan to use it later as well, it’s best to add it to the personal dictionary. This could be useful when you’re using people’s names or company names that are flagged as misspelled words by Google Sheets.
If you have added a word to the dictionary and want to remove it, a prompt usually appears after adding the word with the option to undo it. If you’re ok adding the word, you can just dismiss the prompt. Otherwise, you can undo it.
How to Check Spelling in Google Sheets With an Add-On
To get better and more easily tackled spell-checking in Google Sheets, you can install an add-on. One thing about using addons to check spelling in Google Sheets is that they come with extra features such as the ability to check grammar as well.To install an add-on:
- Navigate to Extensions>Add-ons>Get add-ons
- Type in spell checker in the pop up window
- Download in install the Scribens Spell Checker and Grammar for Google Sheets
Then, to use this software:
- Highlight the cells you want to check
- Navigate to Extensions>Spell checker and Grammar checker by Scribens>Check
- Click Start Correcting
- Click the appropriate selections from the suggestions
Frequently Asked Questions
Why Does Spell Check Not Work in Google Sheets?
It does work, but you have to do it manually on the cells. It doesn’t do it automatically because spreadsheets often contain characters that are not dictionary-recognized words, such as shorthand, etc. So, if you want to use spelling check Google Sheets, you have to highlight the cells manually and navigate to Tools>Spelling>Spell check
Does Google Sheets Have Auto Correct?
No, it doesn’t. You must spell check through the Tools menu because autocorrect would change too many important entries in a spreadsheet.
How Do I Spell Check and Grammar in Google Spreadsheet?
You can check spelling through the built-in spell checker in the Tools menu. Grammar on the other hand, requires you to install an add-on such as the free Scribens one
Learn More About Google Sheets
Google Sheet spelling check is a useful tool that helps you check spelling to avoid spelling mistakes in your spreadsheet. You can use spell check through the tool menu, with a keyboard shortcut or by using an addon. So this is all you need to know about using Google Sheets spell check.
Hope you found this tutorial useful, but don’t let that stop your learning. We have plenty of other Google Sheets tips and tricks to maximize your skills. You might be interested in our article on how to get the Word Count in Google Sheets.
Other Google Sheets tutorials you may like: