Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Setting Spell-Checking Options.

Setting Spell-Checking Options

by Allen Wyatt
(last updated July 6, 2015)

3

Excel includes a spelling checker that you can use to proof the text in your worksheets. There are a few options that you can set for the spelling checker. For instance, you can make sure the spelling checker doesn't check words that are all uppercase or those that have numbers in the word.

To change the spelling checker options, follow these steps:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.)
  2. At the left side of the dialog box click Proofing. (See Figure 1.)
  3. Figure 1. The proofing options in the Excel Options dialog box.

  4. Make changes in the options, as desired.
  5. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6151) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Setting Spell-Checking Options.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Changing Explorer Navigation Controls

Every time Windows updates the operating system, it seems that they leave out or remove something that somebody loved in the ...

Discover More

Adding Comments to Protected Worksheets

When you protect a worksheet, Excel stops users from editing or otherwise making changes to the data in the worksheet. If you ...

Discover More

Odd Arrow Key Behavior

Press the up or down arrow keys, and you expect Excel to change which cell is selected. If this doesn't occur on your ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

MORE EXCELTIPS (RIBBON)

Adjusting Spell Check for Internet Addresses

When you check the spelling of worksheet data, you may want to spell checker to either ignore or check Internet addresses ...

Discover More

Allowing for Words that Contain Numbers

When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 7 + 8?

2017-01-02 06:39:53

Sharon

How can I set the spell check in excel to automatically pick up have the red line underneath a misspelt word and to be able to right click the misspelt word.
thank you


2015-05-18 11:01:33

Steve

Connie,

For Excel 10, go into File, Options, Proofing and click the AutoCorrect Options. Look for "hsa" in the left column and "has" in the righy column, and delete it. The bad news is that if you mis-type "has" as "hsa" it won't correct it. I don't know why it ignores the all capital rule.


2015-05-18 08:06:29

Connie

I still have a probem with HSA (it changes it to HAS). It will only stay HSA if I put periods after each letter even though I asked it to ignore upper case. Does anyone have a suggestion for that?


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share