Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

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

__________________

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>