How to Correct Capital Mistakes in Excel

How many times have you been typing away only to glance down and discover that Caps Lock is on?

Fortunately, Excel can catch these errors for you – IF I tell it to!

Follow the steps below to learn how:

  1. On your Ribbon, Click the Office button and then Excel Options in Excel 2007. In 2010, Click the File tab or your Ribbon and then Options.
  2. At the left side of your screen, click Proofing.

excel commands

  1. Click AutoCorrect Options to display the dialog box.
  2. Display the AutoCorrect tab.
  3. Be certain the Correct Accidental Use of cAPS LOCK Key check box is selected.

Excel autocorrect

  1. Click OK.

Now, if you key in text in a cell and the first letter is lowercase and the rest of the letters are uppercase, Excel knows that I have selected the Caps Lock key and will turn it off.

It will also correct the capitalization of my text entry!

Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *