Excel.Tips.Net ExcelTips (Menu Interface)


AutoCorrect is a useful tool in Excel for applying specific formatting or spelling for certain phrases you often use. Excel pays attention to how you habitually type corrections and imitates your habits to make future typing easier on you. Learn how to take advantage of AutoCorrect and adjust the settings to your preferences with the following articles.

Tips, Tricks, and Answers

The following articles are available for the 'AutoCorrect' topic. Click the article's title (shown in bold) to see the associated article.

Automatically Capitalizing Day Names
When you enter a day name into a cell, Excel automatically capitalizes it. If you want to modify this behavior, follow the steps in this tip.

Backing Up Your AutoCorrect Entries
Want to protect the information that you may be stored in your AutoCorrect entries? Just find a special type of file on your system and you can back up to your heart's content.

Increasing the Capacity of AutoCorrect
AutoCorrect can be a great tool to, well, "correct" information that you type. If you get a little creative, you can even use it to insert large blocks of text in the place of small mnemonics you type. However, AutoCorrect has limits on the length of the replacement text. This tip discusses those limits and at least one way you can work around them.

Turning Off Capital Corrections
Tired of having Excel second-guess you when you type a word that starts with two capital letters? You can turn off this AutoCorrect feature by following the steps in this tip.

Unwanted Data Changes
The AutoCorrect feature in Excel can change some of your data in ways you don't like. If you discover this is happening, here's how to track down the problem and fix it.

Using AutoCorrect
The AutoCorrect feature in Excel is a great tool for quickly entering information. Here's an explanation of the feature and a quick overview of how to use it.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.