Excel.Tips.Net: Setting a Default File Format

By Allen Wyatt for Excel.Tips.Net

Normally, Excel saves your worksheets in the workbook format that is appropriate for the version of the software you are using. This means that your worksheets are stored in a peculiar way that is understood by your version of Excel, but may not be understood by other programs—including earlier versions of Excel.

If you do a lot of work with people who use other versions of Excel or who use a different spreadsheet program, you may want to specify a different default file format for your files. Excel makes this easy; just follow these steps:

1. Display the Excel Options dialog box. (If you are using Excel 2007 click the Office button and then click Excel Options. If you are using Excel 2010 display the File tab of the ribbon and then click Options.)

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

40 total views, 1 views today

(Visited 1 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.