The Florida Bar

Tech Tips

How to Disable Autocorrect One Time on Excel

« Back to Tech Tips

Posted in: Excel, Microsoft or Windows, Tech Tips

Autocorrect, whether in Microsoft Office or text messages, can be a double-edged sword. Without it, your text may be riddled with spelling mistakes and could become very time-consuming to finish and correct tasks. On the other hand, with autocorrect on, you may have to manually change technically correct words but not for autocorrect.

In Excel, there’s a simple solution to dealing with this problem. That way, you don’t necessarily have to turn off AutoCorrect entirely. At the same time, you can temporarily disable autocorrect from changing a term.

No, you don’t have to go all the way in settings to do this. It’s a simple hack that requires just a click of a button or pressing two keys simultaneously. But before we get to that, let’s quickly see how you can turn on autocorrect in Microsoft Excel.

Enable Autocorrect in Microsoft Excel

  • Launch Microsoft Excel.
  • Click on File from the top menu and select Options.
  • Select Proofing from the left side menu.
  • Under the Autocorrect Options section, click on the button Autocorrect Options.
  • In the dialog box that opens, you will see a checklist of different Autocorrect categories, such as capitalizing the first letter of a sentence. Select the options you want to apply.
  • Click Ok to save settings.

Temporarily Disable Autocorrect for Single Situation

Sometimes autocorrect on Microsoft Excel will change a term that is actually correct. This often occurs with names that may be similar to another term. It may also happen with casual/slang words that are not in Excel’s dictionary. Whatever the case may be, you can stop the correction.

After autocorrect has changed a term you don’t want to be changed, press the Spacebar once. Then click on Undo or press Ctr+Z. This action will revert the term back to what you wrote originally.

At the same time, autocorrect would remain enabled to correct other errors that you do want to be corrected in your spreadsheet.

How to Disable Autocorrect

If you do want to disable autocorrect on Excel, you can follow the same steps as you did to enable it in the first place.

  • Click on File from the top menu
  • Select Options
  • Select Proofing from the left side menu
  • Under the Autocorrect Options section, click on the button Autocorrect Options
  • Uncheck all Autocorrect categories
  • Click Ok to save settings.
« Back to Tech Tips