I’ve mentioned many times how heavily I rely on the Google suite of tools. I am fairly sure I have also told you I type insanely fast – to the point I sometimes type words without thinking and do not realize they’re misspelled until Docs underlines them. However, working within Google Sheets is not the same. That program does not underline misspelled words for me! Let me show you how to spell check your work in spreadsheets.
First, let’s take a look at my masterpiece of typos:
You can clearly see the misspelled words. However, what if I was doing extremely technical work and did not notice the glaring errors? Let’s fix this now.
How to Spell Check in Google Sheets
First, you need to highlight the rows or columns you wish to spell check. To select more than one, click the first, hold down the ”CTRL” button, and then continue clicking them until you are finished.
With the rows or columns still highlighted, click ”Tools” at the top of the page. Scroll down to hover over ”Spelling” and then choose ”Spell Check.”
Google will now go through the words it feels are not correct one-by-one, offering suggestions to fix them. You can choose to ”Change,” ”Ignore” (if it is a slang word, for instance) or even ”Add to Dictionary” (as I have done for my made-up word “automagically”.)
If you click the small drop-down arrow on the green ”Change” box, you will see you have the option of allowing Google to ”Change All.” This may save you the time of going through any issues one at a time, but negates the ability to ignore words you want left alone. If you know there is nothing like that in your spreadsheet, then I recommend going ahead and just changing them all at once.
Lastly, you’ll notice another drop-down arrow in the ”Add to Dictionary” box. Select that option, then choose ”View Your Personal Dictionary.” This is where any words appear that you have told Google to save the spellings of so that they will never be mistaken for a misspelled word on any of the Google Docs suite of tools again.
That’s all there is to it! Your spreadsheet is now perfect – as far as spelling words correctly goes. Let’s hope those calculations and formulas are correct.
Do you have any other questions for me regarding Google Sheets? Sound off in the comments.