Excel shortcuts

15 Spell Check Shortcuts for 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 a powerful tool that can help you get the job done.

But as anyone who has ever used Excel knows, it's not always easy to get things right. One small mistake can lead to a big headache, and that's why it's so important to proofread your work carefully.

Fortunately, Excel comes with a built-in spell checker that can help you catch errors before they cause problems. But if you're not familiar with how to use it, the spell checker can be a bit daunting.

To help you get the most out of Excel's spell checker, we've put together a list of 15 shortcuts that can save you time and frustration.

1. Use the F7 Key to Check Spelling

The easiest way to launch the spell checker is to press the F7 key on your keyboard. This shortcut will open the spell checker dialog box, which you can use to scan your entire worksheet for errors.

2. Check Spelling as You Type

If you want to catch spelling errors as you make them, you can enable the "Check spelling as you type" option in the Proofing tab of the Excel Options dialog box.

To access this option, go to the File tab, then click Options. In the Excel Options dialog box, select Proofing from the list of available options. Then, under the "When correcting spelling in Excel" section, select the "Check spelling as you type" check box.

3. Ignore Words in UPPERCASE

By default, the spell checker will flag words that are in all uppercase letters as errors. But if you want to ignore words in uppercase, you can do so by selecting the "Ignore words in uppercase" check box in the Proofing tab of the Excel Options dialog box.

4. Ignore Words with Numbers

Similarly, the spell checker will also flag words that contain numbers as errors. But if you want to ignore these words, you can select the "Ignore words with numbers" check box in the Proofing tab of the Excel Options dialog box.

5. Ignore Internet and File Addresses

If you're working with a lot of data that includes internet or file addresses, you can tell the spell checker to ignore them by selecting the "Ignore internet and file addresses" check box in the Proofing tab of the Excel Options dialog box.

6. Customize Your Dictionary

Excel's spell checker comes with a built-in dictionary of common words. But if you want to add your own custom words to the dictionary, you can do so by selecting the "Custom Dictionaries" button in the Proofing tab of the Excel Options dialog box.

In the Custom Dictionaries dialog box, you can add, edit, and delete custom dictionaries. You can also set a default dictionary, which will be used when checking spelling in multiple languages.

7. Check Spelling in Multiple Languages

If you need to check the spelling of words in multiple languages, you can do so by selecting the "Language" button in the Proofing tab of the Excel Options dialog box.

In the Language dialog box, you can select the languages that you want to use for spell checking. You can also set a default language, which will be used when checking spelling in multiple languages.

8. Use the Spell Checker Tool

If you're not sure how to use the spell checker, you can find a helpful tool by selecting the "Spelling" button in the Proofing tab of the Excel Options dialog box.

In the Spelling dialog box, you can select the options that you want to use for spell checking. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

9. Check Spelling in a Worksheet

If you want to check the spelling in a specific worksheet, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the worksheet that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

10. Check Spelling in a Workbook

If you want to check the spelling in a specific workbook, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the workbook that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

11. Check Spelling in a Selection

If you want to check the spelling in a specific selection, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the selection that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

12. Check Spelling in a Table

If you want to check the spelling in a specific table, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the table that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

13. Check Spelling in a PivotTable

If you want to check the spelling in a specific PivotTable, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the PivotTable that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

14. Check Spelling in a Chart

If you want to check the spelling in a specific chart, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the chart that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

15. Check Spelling in a Shape

If you want to check the spelling in a specific shape, you can do so by selecting the "Check Spelling" command from the Review tab.

In the Check Spelling dialog box, you can select the shape that you want to check. You can also choose to have the spell checker ignore words in uppercase, words with numbers, or internet and file addresses.

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.