Excel tips : spell-checking uppercase words

Excel 753 views 1 replies
User Avatar

MBA (Finance) B.Com.(P)
3443 Points Joined March 2007

Excel Tips : Spell-checking Uppercase Words

 

Excel includes a powerful spell-checker that, in reality, does a pretty good job. You can use this tool to locate potential spelling errors in your worksheets. If your worksheets contain lots of acronyms, you'll find that Excel flags most of them as misspelled words.

You can make sure that Excel ignores uppercase words in any spell-check by following these steps in versions of Excel prior to Excel 2007:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Spelling tab is selected.
  3. Make sure the Ignore Words in UPPERCASE check box is selected.
  4. Click on OK.

To accomplish the same task in Excel 2007, follow these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box click Proofing.
  3. Make sure the Ignore Words in UPPERCASE check box is selected.
  4. Click on OK.

The only downside to this, of course, is if you use all uppercase for section titles or for other special words. In this case, Excel still ignores them, since they are uppercase. Make sure you change the setting of this check box based on the type of work you are doing in your worksheet

Reply Share Follow
On 19 November 2011 at 14:58 Report
Replies (1)
User Avatar

CA Final
3006 Points Joined September 2010
nice info bhai well shared cheers
Reply
On 19 November 2011 at 15:41


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading