Excel shortcuts

The Best Spell Check Shortcuts in Excel

If you're like most people, you probably use Microsoft Excel for a variety of tasks. Whether you're tracking your personal finances, managing a small business, or working on a complex data analysis, Excel is up to the task. But one thing that Excel is not so good at is spell checking.

If you're not careful, misspelled words can slip into your spreadsheets undetected. And once they're there, they can be very difficult to find and correct. That's why it's important to know some of the best spell check shortcuts in Excel.

1. Check spelling as you type

One of the easiest ways to avoid misspelled words in your Excel spreadsheets is to check spelling as you type. This feature is turned on by default in Excel, but you can check to make sure it's enabled by going to the File menu, selecting Options, and then selecting Proofing from the left-hand sidebar. Under the When correcting spelling and grammar in Word section, make sure the Check spelling as you type and Check grammar as you type options are both selected.

With these options enabled, misspelled words will be underlined in red as you type them. To correct a misspelled word, simply right-click on it and select the correct spelling from the drop-down menu. Excel will automatically correct the word for you.

2. Use the spell checker

If you've already entered some text into your spreadsheet and you want to check it for spelling errors, you can use Excel's built-in spell checker. To do this, go to the Review tab on the Excel ribbon and click the Spelling button. Excel will scan your spreadsheet for any words that it thinks might be misspelled and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

3. Ignore words

If you're working with a lot of technical or specialized terms, you might find that the spell checker is constantly flagging words that are actually spelled correctly. In these cases, it can be helpful to tell Excel to ignore certain words. To do this, go to the Review tab on the Excel ribbon and click the Spelling button. Then, click the Ignore button.

Excel will then highlight the next misspelled word in your spreadsheet. To tell Excel to ignore all instances of this word, click the Ignore All button. Excel will then move on to the next misspelled word.

4. Add words to the dictionary

If you find yourself constantly having to tell Excel to ignore certain words, you can add them to the dictionary so that the spell checker will automatically recognize them as being spelled correctly. To do this, go to the Review tab on the Excel ribbon and click the Spelling button. Then, click the Add to Dictionary button.

Excel will then add the word to the dictionary and move on to the next misspelled word.

5. Check for errors in specific cells

If you want to check for spelling errors in specific cells, you can do so by selecting those cells and then going to the Review tab on the Excel ribbon and clicking the Spelling button. Excel will then scan the selected cells for any misspelled words and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

6. Check for errors in specific worksheets

If you want to check for spelling errors in specific worksheets, you can do so by selecting those worksheets and then going to the Review tab on the Excel ribbon and clicking the Spelling button. Excel will then scan the selected worksheets for any misspelled words and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

7. Check for errors in specific workbooks

If you want to check for spelling errors in specific workbooks, you can do so by selecting those workbooks and then going to the Review tab on the Excel ribbon and clicking the Spelling button. Excel will then scan the selected workbooks for any misspelled words and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

8. Check for errors in specific folders

If you want to check for spelling errors in specific folders, you can do so by selecting those folders and then going to the Review tab on the Excel ribbon and clicking the Spelling button. Excel will then scan the selected folders for any misspelled words and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

9. Check for errors in specific files

If you want to check for spelling errors in specific files, you can do so by selecting those files and then going to the Review tab on the Excel ribbon and clicking the Spelling button. Excel will then scan the selected files for any misspelled words and highlight them in red.

To correct a misspelled word, simply click on it and then click the Change button. Excel will suggest a list of alternative spellings. Select the correct spelling from the list and click Change. Excel will automatically correct the word for you.

If Excel doesn't suggest the correct spelling, you can type it in manually by clicking the Change button and then typing the correct spelling in the Change To field. When you're finished, click Change.

10. Check for errors in specific web pages

If you want to check for spelling errors in specific web pages, you can do so by selecting those pages and then going to the <

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.