Let’s face it: there’s nothing more embarrassing than sharing a file, then finding a spelling mistake. But that doesn’t have to happen to you! Let’s learn how to use spell check in Microsoft Excel.
How to Use Spell Check in Excel
You want to make a great impression with any spreadsheet you create. A spelling error can disrupt that. Fortunately, Excel has a built-in spell check feature that’s quick and easy to use.
Consider a list of data like this. Notice that there’s a misspelled word in cell B1. But if you didn’t catch it, you might share the file with the mistake inside.
To run a spell check in Excel, go to the Review tab on the ribbon. Click on it, and you’ll see the Spelling button on the left side of the menu bar. Go ahead and click it.
You’ll see a popup asking if you want to continue checking at the beginning of the sheet. To make sure all of your workbook contents are captured, click Yes.
When an error is found, a new menu will appear. It references the error, and takes you automatically to the cell in question. You have several options to resolve the issue. The Change to box suggests the correct spelling of your word. If you want to apply it, click Change, and the spelling will correct.
Imagine, however, that you’ve not made an actual error, but Excel doesn’t recognize the word. This might happen, especially in the case of names. In this case, you can click Ignore Once or Ignore All to avoid identifying the word as misspelled. And, to prevent it from ever appearing in spell check again, you can click Add to place the word in Excel’s dictionary.
When you’re finished reviewing spelling concerns, press OK.
Spell check only takes a few clicks, but it helps prevent embarrassing mistakes that reduce the quality of your work. Use it any time you need to share a spreadsheet.