peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Watch Your Spelling In Excel

If you use upper case for headings in Excel, spelling errors in them might go uncorrected, such as CAPITEL in the example below.

SpellCaps

To make sure that the headings are included in a spelling check, you can change an option in Excel.

Change the Spelling option in Excel 2007

  1. Click the Office button, then click the Excel Options button
  2. Click the Proofing category
  3. Remove the check mark from 'Ignore words in UPPERCASE' and then click OK

IgnoreCaps

Change the Spelling option in Excel 2003

  1. Click the Tools menu, then click Options
  2. Click the Spelling tab
  3. Remove the check mark from 'Ignore words in UPPERCASE' and then click OK

__________________

Related Posts Plugin for WordPress, Blogger...

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>