Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

Using Named Ranges in a Macro

Selecting Tabs in Dialog Boxes

Pulling Formulas from a Worksheet

 

Allowing for Words that Contain Numbers

Summary: When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it takes is a simple change to the configuration options for the spell-checker. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Have you ever noticed that one of the side effects of our fast-paced world is the creation of new words? It seems that every day—particularly in the technological or medical fields—that new words are bursting forth on the scene. Some of these words are actually composed of letters and numbers together. For instance, b2b is an acronym (word?) meaning business-to-business.

Normally such words would be flagged by Excel's spelling checker as being incorrect. If you create worksheets that contain quite a few words that are formed by mixing letters and numbers, you may want to instruct Excel to ignore them. You can do so by following these steps if you are using a version of Word prior to Word 2007:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Spelling tab is selected. (Click here to see a related figure.)
  3. Make sure the Ignore Words with Numbers check box is selected.
  4. Click on OK.

If you are using Excel 2007 then the steps are a bit different:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Click Proofing at the left side of the dialog box. (Click here to see a related figure.)
  3. Make sure the Ignore Words that Contain Numbers check box is selected.
  4. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3380) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
 
Check out ExcelTips Premium today!