Cellwise Start free

Excel guide · 4 min read

How to stop Excel AutoCorrect changing your text

Quick answerPress Ctrl+Z straight after Excel changes what you typed: it undoes only the AutoCorrect and keeps your text. To stop it for good, go to File > Options > Proofing > AutoCorrect Options, and delete the entry from the Replace text as you type list (such as (c) → ©) or untick the rule that's catching you. Cells that already changed can be fixed with Find and Replace or =SUBSTITUTE(A2,"©","(c)").

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABC
1ReferenceOwnerStatus
2Section 4(a)PriyaAgreed
3Section 4(b)PriyaAgreed
4Section 4©TomOpen
5Section 7(a)TomAgreed
6Section 7©PriyaOpen
7Section 9(d)TomOpen

Download this sheet as an Excel practice file (.xlsx)

Undo one change with Ctrl+Z

AutoCorrect runs when you type, and Excel records its change as a separate step after your typing. So if you type Section 4(c), press Enter and see Section 4©, pressing Ctrl+Z once puts back exactly what you typed. Press it a second time and your whole entry is undone.

This is the quickest fix when the change is a one-off. If it keeps happening (a contract tracker full of clause references, a list of options labelled (a) (b) (c)), change the rule instead.

Delete or change a Replace text entry

The symbols and spelling fixes come from one list: (c) becomes ©, (r) becomes ®, (tm) becomes ™, and common typos like teh become the. You can remove just the entry that bothers you and keep the rest.

The AutoCorrect list is shared with the other Office apps on your computer, so deleting (c) here also stops Word and Outlook changing it.

  1. Go to File > Options > Proofing and click AutoCorrect Options.
  2. On the AutoCorrect tab, type (c) in the Replace box to jump to the entry.
  3. Click Delete, then OK twice. Or untick Replace text as you type to switch off the whole list.
  4. On a Mac: Excel > Preferences (Settings in newer versions) > AutoCorrect.

The capitalisation rules

The same tab has rules that change capital letters: Correct TWo INitial CApitals, Capitalize first letter of sentences, Capitalize names of days, and Correct accidental use of cAPS LOCK key. They're why monday turns into Monday, or why a code typed with two capitals at the start comes back with one.

Untick the one you don't want. If only a few words are affected, the Exceptions button lets you keep the rule and list the words it should leave alone.

Links, tables and the AutoFormat As You Type tab

Two more automatic changes live on the AutoFormat As You Type tab of the same dialog. Internet and network paths with hyperlinks turns a typed web address or file path into a clickable link; see Excel hyperlink not working if you want the opposite. Include new rows and columns in table makes an Excel table grow when you type next to it, and Fill formulas in tables to create calculated columns copies a formula down a whole table column.

Untick any of these if they get in your way. Ctrl+Z straight after the change undoes these too.

  1. File > Options > Proofing > AutoCorrect Options.
  2. Click the AutoFormat As You Type tab.
  3. Untick the option you don't want and click OK twice.

Fix cells that already changed

If a column has been typed with AutoCorrect on, some cells already hold the © symbol. First see how many, with COUNTIF and a wildcard. Then either use Home > Find & Select > Replace (Find what: ©, Replace with: (c), Replace All), or use SUBSTITUTE in a helper column if you want to check the result first.

To type the © symbol itself on Windows, use Alt+0169 on the number pad, or Insert > Symbol.

=COUNTIF(A2:A7,"*©*")

Result: 2

2: Section 4© and Section 7© were changed by AutoCorrect.

Fix the whole column with a formula

SUBSTITUTE swaps every © for (c). In Excel 365 one formula spills down the column; in older versions write it for A2 and fill down. Then copy the results and use Paste Special > Values over the original column.

=SUBSTITUTE(A2:A7,"©","(c)")

Result: spills 6 rows × 1 column

Section 4(a)
Section 4(b)
Section 4(c)
Section 7(a)
Section 7(c)
Section 9(d)

Section 4(a), Section 4(b), Section 4(c), Section 7(a), Section 7(c), Section 9(d) spill down.

Numbers turning into dates isn't AutoCorrect

If 1/2 turns into 2-Jan or a part number like 3-4 becomes a date, turning AutoCorrect off won't help. That's Excel recognising the entry as a date when you press Enter, a separate feature with no setting in AutoCorrect Options. Type an apostrophe first ('1/2) to keep it as text, type 0 1/2 to enter the fraction one half, or format the cells as Text before typing. Stop Excel changing numbers to dates covers every case.

Common mistakes

Turning off every AutoCorrect option

You lose the typo fixes you actually like. Delete the one entry or untick the one rule that bothers you.

Unticking Show AutoCorrect Options buttons

That only hides the little button that can appear after a change. The changes keep happening; remove the entry or untick the rule itself.

Fixing © by hand one cell at a time

Find and Replace, or SUBSTITUTE in a helper column, fixes a whole column at once.

FAQ

How do I turn off AutoCorrect in Excel?

File > Options > Proofing > AutoCorrect Options. Untick Replace text as you type to stop replacements, and untick the capitalisation rules you don't want.

Why does Excel change (c) to the copyright symbol?

(c) → © is an entry in the AutoCorrect Replace text as you type list. Press Ctrl+Z right after it happens, or delete the entry in AutoCorrect Options.

Does changing AutoCorrect in Excel affect Word?

The Replace text list is shared across Office apps on the same computer, so removing an entry in Excel also removes it in Word and Outlook.

Why does Excel capitalise the days of the week?

The Capitalize names of days rule is on. Untick it on the AutoCorrect tab of AutoCorrect Options.

Functions used

Related guides

Updated