F7 in Excel: How to Check Spelling in a Worksheet

Have you ever finished entering data in Excel and wanted to check whether there are any spelling mistakes?

You don’t need to check every cell manually. Excel has a built-in Spell Check feature that helps you find and correct spelling mistakes.

You can quickly open it using the F7 keyboard shortcut.

Let’s see how it works.

Keyboard Shortcut for Spell Check in Excel:

The keyboard shortcut to check spelling in Excel is:

F7

How to Check Spelling in Excel Using F7?

Follow these steps:

1. Open your Excel worksheet.

2. Select the cell where you want to start checking spelling. If you want to check the entire worksheet from the beginning, select cell A1.

3. Press F7 on your keyboard.

Excel opens the Spelling dialog box and starts checking the worksheet for spelling mistakes.

If Excel finds a spelling mistake, it displays the word along with suggested corrections.

You can choose from the following options:

• Ignore Once: Skips the current spelling mistake.
• Ignore All: Ignores all occurrences of the same word.
• Add to Dictionary: Adds the word to your custom dictionary.
• Change: Replaces the current word with the selected suggestion.
• Change All: Replaces all occurrences of the word with the selected suggestion.
• AutoCorrect: Adds the correction to AutoCorrect so Excel can automatically correct the same mistake in the future.

Choose the appropriate option to continue checking your worksheet.

Practical Example:

Suppose you have the following employee data:

Employee	Department
Ravi	Sales
Priya	Markting
Kiran	Finance

Here, the word Markting is misspelled.

To correct it:

1. Click any cell in the worksheet.

2. Press F7.

3. Excel identifies the spelling mistake and suggests Marketing.

4. Select the correct suggestion.

5. Click Change.

Excel replaces the misspelled word with Marketing.

Can You Check Spelling in Multiple Worksheets?

Yes. You can check spelling across multiple worksheets in the same workbook.

Follow these steps:

1. Select the worksheet tabs you want to check by holding Ctrl and clicking each tab.

2. Press F7.

3. Excel checks the selected worksheets for spelling mistakes.

Note: When you group worksheets, any changes you make to one selected worksheet may also affect the other grouped worksheets. Ungroup them after checking.

Important Things to Remember:

• F7 opens the Spelling dialog box in Excel.
• Excel checks spelling in cell contents, including text entries.
• Spell Check does not automatically correct every mistake. You need to review the suggestions.
• Excel does not check spelling inside formulas.
• Spell Check does not identify grammatical mistakes.

Frequently Asked Questions:

1. What is the shortcut for Spell Check in Excel?

Press F7 to open the Spelling dialog box and check spelling in your worksheet.

2. Does F7 check the entire Excel worksheet?

Yes. If you select any single cell and press F7, Excel checks the worksheet.

3. Can Excel automatically correct spelling mistakes?

Excel provides an AutoCorrect option that can automatically correct certain spelling mistakes. You can also use Change or Change All in the Spelling dialog box.

4. Does Spell Check work in Excel formulas?

No. Excel’s Spell Check feature checks text, not formula syntax or formula errors.

5. What should I do if F7 does not open Spell Check?

On some laptops, you may need to press Fn + F7 because the function keys have additional hardware controls.

Final Thoughts:

The F7 shortcut makes it easy to check spelling mistakes in Excel without going through the Ribbon.

Whenever you finish entering data, press F7 to review your worksheet and correct spelling mistakes.

For more useful shortcuts, visit our Excel Keyboard Shortcuts page.