How to stop autocorrect (c) to © only in Excel？
Usually, when we type (c) into a cell in Excel, it will be corrected to © automatically. Sometimes, you just need to stop this autocorrect (c) to ©, how can you get it done in Excel?
Only to stop autocorrect (c) to © in Excel, you can do as follow:
1. Enable Excel, and click File or Office button > Option > Proofing > AutoCorrect Options. See sceenshots:
2. In the pop-up dialog, select (c) to © from the drop-down list, and then click the Remove buton. Or you can select the (c) to ©, and then replace the © with (c) in the With text box. See screenshots:
3. Click Replace > Yes > OK > OK to close all the dialogs, now when you type (c) into a cell, it will show just (c). See screenshot:
1. If you want to returen autocorrect (c) to ©, just need to go back to the AutoCorrect dialog, and type © into the With text agin.
2. Enter formula =CHAR(169) or hold on ALT and press 0169, you also can get ©.
Best Office Productivity Tools
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!