When working in Excel, typing errors can slow down your work and make spreadsheets look unprofessional. Excel includes a built-in AutoCorrect feature that automatically fixes common spelling mistakes, typing errors, and abbreviations as you type. In this article, you will learn all about AutoCorrect in Excel.
Key Takeaways:
- AutoCorrect automatically fixes common typing mistakes in Excel.
- You can create custom shortcuts for frequently used words and phrases.
- AutoCorrect helps improve typing speed and accuracy.
- Special symbols and text can be inserted using custom entries.
- AutoCorrect settings can be edited or turned off when needed.
Table of Contents
How to Use AutoCorrect in Excel
What is AutoCorrect?
AutoCorrect is a feature in Excel that automatically replaces mispelled words with the correct word that you have provided. For example, if you accidentally type “teh”, Excel can automatically change it to “the”. AutoCorrect can also replace abbreviations, symbols, and custom text entries.
How to Access AutoCorrect
- Open Excel.
- Click the File tab.
- Select Options.
- Click Proofing.
- Select AutoCorrect Options.
- Enter the mispelled word or abbreviations in the Replace field
- Enter the correct word in the ” With field
- Click OK
Efficient Data Entry with Excel Autofix
Custom Abbreviations
If you need to type a long word more than you can count, you can set a custom abbreviation for it in Excel. For example, you can set IWC to automatically expand to International Widget Cooperation. This can reduce minutes or even hours off your worksheet. You can use this for any lengthy terms you often use.
Remember to select abbreviations that are unique and not part of your standard text, to prevent accidental triggers.
Insert Special Symbols
Suppose you need to add a particular symbol often in your spreadsheet, you can assign a text to that shortcut. Imagine needing to insert the delta symbol frequently in your analysis. By setting up “DELTASYM” as a shortcut, hitting those keys will swiftly transform them into a delta symbol.
Tailoring Autocorrect to Suit Your Needs
Adding Personal Touches to the Autocorrect List
Personalizing Excel’s Autocorrect list can feel like setting up your own secret codes. By adding your own set of shortcuts and expansions, you essentially create a unique dialect between you and your spreadsheet. This could be anything from turning “mths” into “months” to replacing “qrtr” with “quarterly report figures.” The possibilities are limitless and uniquely yours.
To get started, you just open the Autocorrect options and populate your personal list. It’s like teaching Excel your own language—one that streamlines your data entry and cuts down on the monotony of repetitive typing.
Preventing Excel from Overstepping with Autocorrect
Have you ever been a tad annoyed when Excel decides to ‘help’ by changing what you typed into something else entirely unintended? Well, you’re not alone. It’s important to keep Autocorrect on a leash, to ensure it doesn’t overstep and become more of a hindrance than a help. Sometimes keeping control means taking a step back and selectively turning off certain features that don’t fit your needs or adjusting its behavior for specific entries.
You can stop Excel from making certain changes by delving into the Autocorrect settings and unchecking the options that aren’t serving you. This way, you maintain the benefits of Autocorrect while curtailing its over-eager tendencies.
Common Pitfalls and How to Avoid Them
Turning Off Unwanted Autocorrect Functions
Sometimes, you may not need to autocorrect words in Excel. It is advisable to turn off the AutoCorrect feature.
Go to File > Options > Proofing > AutoCorrect Options and uncheck the settings you do not need.
But, you should keep in mind that turning off this feature will mean that genuine misspelled words will also not be corrected.
Undoing Unintentional Changes Swiftly
Excel autocorrected your entry, and you didn’t mean for it to happen. There is a quick fix to reverse those automatic changes.
Hit Ctrl + Z right after the autocorrection, and it reverts to what you initially typed.
Advanced Tips for Power Users
Store Complex Formulas
You can store long, complex formulas as simple text using AutoCorrect shortcuts. It saves the risk of errors from manual formula entry and reduces copy-pasting between worksheets. It saves time when using the same formulas repeatedly.
Additional Tips
- You can create shortcuts for commonly used text.
- Insert long phrases with just a few keystrokes.
- Speed up data entry in large spreadsheets.
- Reduce repetitive typing work.
- Focus more on analysis and less on data entry.
FAQs
1. What is AutoCorrect in Excel?
AutoCorrect automatically replaces incorrect text with the correct text as you type.
2. How to open AutoCorrect settings?
To open AutoCorrect settings,
- Go to File
- Select Options
- Select Proofing
- Click on AutoCorrect Options
3. How to undo an AutoCorrect change?
You can press Ctrl + Z immediately to undo an AutoCorrect change. It will revert to the original word.
4. How to disable AutoCorrect in Excel?
To disable AutoCorrect in Excel,
- Go to File
- Select Options
- Select Proofing
- Click on AutoCorrect Options
- Uncheck the AutoCorrect features you want to turn off.
5. Can I create my own AutoCorrect shortcuts in Excel?
Yes, Excel allows you to create custom AutoCorrect entries.
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.
30 Days - Full Access 
