bottom
Excel 2007 Tips!
     
Your e-mail address is safe!
Close Note
excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Cleaning Tips
Excel2007 Tips
Health Tips
Pet Tips

Newest Tips

Correcting Pale Shading of Selected Cells

Drawing Borders

Converting Numeric Values to Text Values

Specifying Fonts for the Web

Easily Dividing Values by a Set Amount

Adding Text to a Shape

Unwanted Files Loading when Starting Excel

 

Spell-Checking Words Containing 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.

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:

  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.