Computing Staff
  • 0

Auto Correct Question With Excel

  • 0

How do you turn off auto correct in one cell of Excel. I’m trying to type HDA and it keeps changing it to HAD.

Share

1 Answer

  1. Autocorrect is all or nothing. However, you can remove auto correction words from the office dictionary. To do that for excel 2007 and newer, click the windows icon/file button in the top left corner and click on options. Once in the options menu, click on ‘Proofing’ and click on the ‘AutoCorrect Options’ button.
    In the window that pops up on the ‘AutoCorrect’ tab, scroll through the list until you find ‘hda-had’ and delete it from the list.

    Your other option is to just turn off the ‘Replace text as you type’ feature by un-selecting its check box.

    • 0