Backing Up Your AutoCorrect Entries

Summary: 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. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

AutoCorrect is a very productive feature in Microsoft Office products that allows you to compensate for your inadequacies as a typist (grin). Since it is possible to spend a great deal of time tweaking your AutoCorrect entries so they are just right, you may wonder how to back up the information in case they need to move it to a freshly formatted hard drive or a new install of Excel.

The answer is quite simple: Excel's AutoCorrect information is stored in files with the ACL extension. If you want to make a copy of your AutoCorrect information, all you need to do is use the Windows searching capabilities to locate files with this extension and copy them to your backup destination (such as a memory stick).

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2087) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Backing Up Your AutoCorrect Entries