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.

  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.

  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!

Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!