Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

In Microsoft Excel, workbooks are saved as Excel Workbooks (.xlsx) by default. You can change the default file format to any other file format that is supported in Excel. For example, if you frequently create macros in a workbook, you may want to automatically save a new workbook as an Excel Macro-Enabled Workbook (.xlsm). Or, if you work with others who use earlier versions of Excel, you may want to save a new workbook as an Excel 97-2003 Workbook (.xls).

  1. In Excel 2007: Click the Microsoft Office Button Office button image, and then click Excel Options.

    In all other Excel versions: click File > Options.

  2. In the Save category, under Save Workbooks, in the Save files in this format list, click the file format that you want to use.

    Tip: For more information, see File formats that are supported in Excel.

Notes: 

  • After you specify the default file format, all new workbooks are saved in the selected file format unless you specify a different format in the Save As dialog box when you save a workbook.

  • Some features and formatting might not be available if you save the workbook in the file format of an earlier version of Microsoft Excel or another spreadsheet program.

    For more information, see Excel formatting and features that are not transferred to other file formats.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×