bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Tools > AutoCorrect > Backing Up Your AutoCorrect Entries

Backing Up Your AutoCorrect Entries

Summary: If you've invested a great deal of time in putting together your own set of AutoCorrect entries, you know that they are a valuable asset that you need to protect. This tip explains how you can do just that by backing up the entries in a safe manner. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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: 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 Find File (within Windows) to locate files with this extension and copy them to a floppy or some other storage device.

Tip #2087 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


More Power! Expand your skills and make Excel really sing! It's all possible with macros. The best resource anywhere for macros is ExcelTips: The Macros. Check it out today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)