Excel 2007 - Check spelling and grammar

LikeOffice Excel Consulting

Excel Consulting

|

|

Functions

|

|

|

Members

Utility for Excel:

- Compare worksheets
- Database analysis
- Stock to your Excel
- Password recovery
- and many more...

This page presents how to work with Microsoft Excel 2007 features and its redesigned interface. You may also visit our Excel Question page.

Check spelling and grammar

Your Microsoft Office program provides tools that can help you correct mistakes. You can check spelling and grammar in your files all at once, or you can let your Microsoft Office program suggest corrections automatically while you work.

What do you want to do?

Check spelling and grammar all at once

Check spelling and grammar automatically

Fix problems with the spelling and grammar checker

Check spelling and grammar all at once

Checking all of the spelling and grammar in a file is useful when you want to proof your text after you finish editing it. You can check for possible mistakes and then confirm each correction.

Do the following in these Microsoft Office programs:

Which 2007 Microsoft Office system program are you using?

SharePoint Designer

Access

On the Review tab, in the Proofing group, click Spelling.

Tip You can access this command quickly by adding it to the Quick Access Toolbar, which is a part of the Microsoft Office Fluent user interface, by right-clicking the Spelling button, and then clicking Add to Quick Access Toolbar on the shortcut menu.

If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the Not in Dictionary box.
Edit the word.
Click Change.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Select the correct word from the Suggestions list, and then click AutoCorrect.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

Excel

On the Review tab, in the Proofing group, click Spelling.

Tip You can access this command quickly by adding it to the Quick Access Toolbar, which is a part of the Microsoft Office Fluent user interface, by right-clicking the Spelling button, and then clicking Add to Quick Access Toolbar on the shortcut menu.

If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the Not in Dictionary box.
Edit the word.
Click Change.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Select the correct word from the Suggestions list, and then click AutoCorrect.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

InfoPath

On the Tools menu, point to Spelling, and then click Spelling.
If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the word in the file, and edit the word as needed to fix the word.
After you fix the word, click Find Next in InfoPath, Start Spell Check in OneNote, or Resume for all other programs.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Find Next.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Because these programs do not support the AutoCorrect feature, there is no way to make the program automatically fix mistakes while you type.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

OneNote

On the Tools menu, point to Spelling, and then click Spelling.
If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the word in the file, and edit the word as needed to fix the word.
After you fix the word, click Find Next in InfoPath, Start Spell Check in OneNote, or Resume for all other programs.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Click AutoCorrect options.
Type the mistake in the Replace box, and then type the correct spelling in the With box.
Click Add.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

Outlook

Create or open an item, such as an e-mail message, appointment, or contact, and then on the Write tab, in the Proofing group, click Spelling.

Tip You can access this command quickly by adding it to the Quick Access Toolbar, which is a part of the Microsoft Office Fluent user interface, by right-clicking the Spelling button, and then clicking Add to Quick Access Toolbar on the shortcut menu.

If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the word in the file, and edit the word as needed to fix the word.
After you fix the word, click Find Next in InfoPath, Start Spell Check in OneNote, or Resume for all other programs.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

Important Clicking Ignore All in Outlook causes the spelling checker to ignore all existing instances of the word, permanently. In Outlook, you can make the spelling checker find these ignored words again.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Select the correct word from the Suggestions list, and then click AutoCorrect.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.
In Outlook or Word only, after the program finishes flagging the spelling mistakes, it begins showing you the grammar mistakes. For each mistake, select an option in the Spelling and Grammar dialog box.

PowerPoint

On the Review tab, in the Proofing group, click Spelling.

Tip You can access this command quickly by adding it to the Quick Access Toolbar, which is a part of the Microsoft Office Fluent user interface, by right-clicking the Spelling button, and then clicking Add to Quick Access Toolbar on the shortcut menu.

If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the word in the file, and edit the word as needed to fix the word.
After you fix the word, click Find Next in InfoPath, Start Spell Check in OneNote, or Resume for all other programs.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

Important Clicking Ignore All in PowerPoint causes the spelling checker to ignore all existing instances of the word, permanently. There is no way to make PowerPoint find instances of a misspelled word after you click Ignore All for the word.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Select the correct word from the Suggestions list, and then click AutoCorrect.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

Publisher

On the Tools menu, point to Spelling, and then click Spelling.
If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the Not in Dictionary box.
Edit the word.
Click Change.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

First you must either cancel or complete the spelling check.
On the Tools menu, select AutoCorrect Options.
Type the mistake in the Replace box, and then type the correct spelling in the With box.
Click Add.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

SharePoint Designer

On the Tools menu, point to Spelling, and then click Spelling.
If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the Change to box.
Edit the word.
Click Change.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Because these programs do not support the AutoCorrect feature, there is no way to make the program automatically fix mistakes while you type.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

Visio

On the Tools menu, point to Spelling, and then click Spelling.
If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the Change to box.
Edit the word.
Click Change.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

First you must either cancel or complete the spelling check.
On the Tools menu, select AutoCorrect Options.
Type the mistake in the Replace box, and then type the correct spelling in the With box.
Click Add.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.

Word

On the Review tab, in the Proofing group, click Spelling & Grammar.

Tip You can access this command quickly by adding it to the Quick Access Toolbar, which is a part of the Microsoft Office Fluent user interface, by right-clicking the Spelling & Grammar button, and then clicking Add to Quick Access Toolbar on the shortcut menu.

If the program finds spelling mistakes, a dialog box or task pane is displayed, and the first misspelled word found by the spelling checker is selected.
You can resolve each error that the program finds in different ways.

I want to fix the error by using one of the suggested words.

Select the word from the Suggestions list, and then click Change.

I want to fix the error by changing the word, myself.

Click the word in the file, and edit the word as needed to fix the word.
After you fix the word, click Find Next in InfoPath, Start Spell Check in OneNote, or Resume for all other programs.

The misspelled word is actually a real word that I use. I want all of the Microsoft Office programs to recognize this word and not treat it as a misspelling.

Click Add or Add to Dictionary.

I want to ignore this misspelled word and move on to the next misspelled word.

Click Ignore Once.

I want to ignore all instances of this misspelled word and move on to the next misspelled word.

Click Ignore All.

Important Clicking Ignore All in Word causes the spelling checker to ignore all existing instances of the word, permanently. In Word, you can make the spelling checker find these ignored words again.

I tend to make this mistake a lot, so I want the program to automatically fix this mistake for me whenever I type it.

Select the correct word from the Suggestions list, and then click AutoCorrect.

After you resolve each misspelled word, the program flags the next misspelled word so that you can decide what you want to do.
In Outlook or Word only, after the program finishes flagging the spelling mistakes, it begins showing you the grammar mistakes. For each mistake, select an option in the Spelling and Grammar dialog box.

Check spelling and grammar automatically

If you are looking for a way to find and fix spelling mistakes in your file more quickly and easily, or if you don't want to see the wavy red lines that your Microsoft Office program displays in your file, this section explains how automatic spelling and grammar checking works and how to turn it on or off.

Notes

There is no option to check spelling while you type in Access, Excel, or Project.
Grammar checking is available only in Outlook and Word.

How automatic spelling checking works

When you check spelling automatically while you type, you can be more confident that you won't need to correct a lot of spelling mistakes when you are ready to deliver your file. Your Microsoft Office program can flag misspelled words while you work so that you can easily spot them, as in the following example.

You can right-click the misspelled word to see suggested corrections on the shortcut menu.

Depending on the Microsoft Office program that you are using, right-clicking a word can provide you with other options on the shortcut menu, such as adding the word to your custom dictionary.

How automatic grammar checking works (Outlook and Word only)

After you turn on automatic grammar checking, Word and Outlook flag the potential grammar and style mistakes while you work in Word documents and in opened Outlook items (except Notes), as shown in the following example.

You can right-click the mistake for more options on the shortcut menu.

On the menu that is shown, you may be given a suggested correction. You also can choose to ignore the error or click About This Sentence to see why the program considers the text to be a mistake.

Turn on or off automatic spelling and grammar checking

Which 2007 Microsoft Office system program are you using?

Outlook

On the Tools menu, click Options.
Click the Spelling tab, and then click Spelling and AutoCorrection.
Select or clear the Check spelling as you type and Check grammar as you type check boxes.

Note The spelling and grammar checkers are available for all items except Notes.

Word

Click the Microsoft Office Button , and then click Word Options.
Click Proofing.
To turn on or off automatic spelling checking and automatic grammar checking for the currently open document, do the following:
1. Under Exceptions for, click Name of currently open file.
2. Select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.

To turn on or off automatic spelling checking and automatic grammar checking for all documents that you create from now on, do the following:

Under Exceptions for, click All New Documents.
Select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.

Important If you turn off automatic spelling checking or automatic grammar checking for a file that you share with other people, you may want to notify those people that you made this change.

Turn on or off automatic spelling checking

Which 2007 Microsoft Office system program are you using?

SharePoint Designer

InfoPath

On the Tools menu, click Spelling, and then click Spelling Options.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

OneNote

On the Tools menu, click Spelling, and then click Spelling Options.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

PowerPoint

Click the Microsoft Office Button , and then click PowerPoint Options.
Click Proofing.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

Publisher

On the Tools menu, click Spelling, and then click Spelling Options.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

SharePoint Designer

On the Tools menu, click Spelling, and then click Spelling Options.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

Visio

On the Tools menu, click Spelling, and then click Spelling Options.
Select or clear the Hide spelling errors check box.

Note If you want to select this check box, you must also select the Check spelling as you type check box.

Note This feature is not available in Access, Excel, and Project.

AutoCorrect

In some programs, you can also use AutoCorrect to automatically correct spelling as you type, without having to confirm each correction. For example, if you type definately and type a space or other punctuation, the AutoCorrect feature automatically replaces the misspelled word with definitely. Find links to more information about AutoCorrect in the See Also section.

Fix problems with the spelling and grammar checker

Find links to information about troubleshooting problems with the spelling and grammar checkers in the See Also section.

See Also

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
©2003-2009 LikeOffice - Privacy Policy - Contact us