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

Tips.Net > ExcelTips Home > Files > Using Your Own File Extensions

Using Your Own File Extensions

Summary: Excel uses the familiar XLS filename extension for its workbooks. If you want to use a different extension, you can use the file naming techniques described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

By default, Excel uses an XLS extension for all workbook files. You can, however, control exactly what extensions Excel uses with your workbooks. (You may want to use a different extension if you are trying to hide the fact that the file is an Excel workbook.) If you try to use a different file name extension by including it when you save the file, Excel still appends the XLS extension. For instance, if you explicitly save a file as MyFile.mef, Excel will still save it as MyFile.mef.xls.

If you don't want Excel to do this, then simply enclose your file name in quotes when you save under a new name. Thus, you would use the name "MyFile.mef" (with the quotes) and that is the file name which Excel will use.

In addition, if you save a workbook with a different extension (not using XLS), then Excel won't show the workbook by default when you use the Open command. To see all your varied-extension files, you need to follow these steps:

  1. Click on the Open icon on the toolbar, or choose Open from the File menu. Excel displays the Open dialog box.
  2. In the File Name field, enter an asterisk, period, and your desired extension. For instance, you could enter "*.mef" (without the quotes).
  3. Press Enter. The desired files should be listed in the directory.
  4. Select the file you want to open.
  5. Click on Open.

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


Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

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.)