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 spell check Google Sheets?
While Google Sheets is more about data entry, record keeping, and data analysis, you may still need to run spell in it from time to time.
A lot of people also use Google Sheets with a lot of text data. And in such cases, spell check is a must.
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 do it.
So let’s get started!
Using Spell Check in Google Sheets
For spell check to work in Google Sheets, you need to select all ṭhe cells where you want to check for misspelled words. This could be a specific range of cells or the entire sheet.
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 would run the spell check and you will see it open as a separate dialog box in the top right part of the Google Sheets.
Spell Check Keyboard Shortcut
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:
- 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 below keyboard shortcut to run spell-check in Google Sheets:
Understanding Spell Check Options
When you run spell check in Google Sheets, you now have a couple of options:
- Change: You can change ṭhe misspelled word with the suggestion. In case the suggestion is not correct, you can also enter the correct spelling. You can also do this for each cell one-by-one or apply this change to all at one go.
- Ignore: 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
- Add to Dictionary: If spell check highlights a word that is correct and you plan to use it later as well, it’s best to add it to the personal dictionary. This could be useful in case when you’re using people’s names or company names that are flagged as misspelled words by Google Sheets.
So this is all you need to about using spell check in Google Sheets.
Hope you found this tutorial useful.
Other Google Sheets tutorials you may like: