Excel guide · 4 min read
How to stop Excel AutoCorrect changing your text
=SUBSTITUTE(A2,"©","(c)").Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | Reference | Owner | Status |
| 2 | Section 4(a) | Priya | Agreed |
| 3 | Section 4(b) | Priya | Agreed |
| 4 | Section 4© | Tom | Open |
| 5 | Section 7(a) | Tom | Agreed |
| 6 | Section 7© | Priya | Open |
| 7 | Section 9(d) | Tom | Open |
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.
- Go to File > Options > Proofing and click AutoCorrect Options.
- On the AutoCorrect tab, type (c) in the Replace box to jump to the entry.
- Click Delete, then OK twice. Or untick Replace text as you type to switch off the whole list.
- 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.
- File > Options > Proofing > AutoCorrect Options.
- Click the AutoFormat As You Type tab.
- 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.
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.
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
- Excel spell check not working: why it skips words and how to fix it
- Excel hyperlink not working: 7 fixes
- How to stop Excel changing numbers to dates
- Excel Find and Replace not working: 8 fixes
- How to insert the degree symbol in Excel
- How to create an email address from first and last name in Excel
Updated