• Curran@CurranOmniMedia.com

How To Use Spell Check in an Excel Spreadsheet or Workbook

How To Use Spell Check in an Excel Spreadsheet or Workbook

This came up in a conversation with my boss . .  How do you spell check Excel?

There are two ways, you can check a single spreadsheet or an entire workbook.

To check a single sheet

  1. Click where where you want to start the spell check.
    • If you click in the first cell (a1) it will check the entire sheet.
    • If you click in cell zz99 it will start spell checking from there.
    • If you select a range of cells only those cells will be checked.
  2. Go to the Ribbon.
  3. Select the Review tab.
  4. Select Spelling.

To spell check all of the sheets in a workbook:

  1. Right-click on a sheet tab at the bottom of your Excel spreadsheet.
  2. Click Select All Sheets.
  3. Go to the Ribbon.
  4. Select the Review tab.
  5. Select Spelling.

For a shorcut to any of these procedures you can simply make your selection and then press F7 on your keyboard.

If you are not an F7 remembering type of person try this:

  1. Go to the Review tab
  2. Right click on Spelling
  3. Select “Add to Quick Access Toolbar
  4. Right click in the ribbon and make sure you select “Show Quick Access Toolbar

I like my quick access tool bar at the top of Excel as well, like this:

So no more mispllled werds in Excell!

15 Comments

  • bcheese

    January 27, 2010 at 5:54 am

    not 2003 it dont

  • Mazza

    September 3, 2010 at 7:47 am

    Marvellous – used it today!!!
    Many thanks.

    Grace

    September 17, 2010 at 9:02 am

    a lifesaver! many thanks!

    sonia

    January 6, 2011 at 3:20 am

    Fantastic than you !!

    suomijock

    August 2, 2011 at 9:59 pm

    Yes, definitely works with excel 2007. Thanks!

    Abhishek

    August 16, 2011 at 10:03 pm

    Fabulous .. thanks ..

    facebook status

    October 17, 2011 at 3:16 am

    nice work i like it

    Nilamani

    December 15, 2011 at 5:19 am

    GOOD JOB

    abbas

    February 2, 2012 at 4:54 am

    nice job

    MM-SA

    April 17, 2012 at 8:12 pm

    Yayyyyyyyyyyyyy thanks!!!

    Cristin Rhea

    April 26, 2012 at 11:10 pm

    There are two ways, you can check a single spreadsheet or an entire workbook.

    sriram

    August 21, 2012 at 1:40 am

    thanks a lot

    DeVi

    October 25, 2012 at 5:00 am

    What is the "Ribbon" on Excel?

    Praveen

    February 5, 2013 at 1:58 am

    THANKS Daniel!!

    econ

    February 6, 2013 at 1:21 pm

    thanks

Leave a Reply

%d bloggers like this: