Save a workbook in another file format

Try Office 2010 In Excel 2010, you can use other formats such as PDF and XPS.
Read an article or try Office 2010!

You can save a Microsoft Office Excel 2007 workbook in a different file format. You can save a workbook in an earlier version file format, in text file format, and in other file formats, such as PDF or XPS. You can also save any file format that you can open in Office Excel 2007 as an Excel 2007 workbook. By default, Excel 2007 saves files in the .xlsx file format, but you can change the default file format for saving.

If you frequently use the Save As command, you may want to add it to the Quick Access Toolbar.

What do you want to do?


Save an Excel 2007 workbook in a different file format

 Important   If you save a workbook in a file format other than the Excel 2007 file format , formats and features that are unique to Excel 2007 will not be retained. For more information, see Formatting and features that are not transferred in Excel file format conversions.

  1. Open the workbook that you want to save for use in another program.
  2. Click the Microsoft Office Button Button image, and then click Save As.
  1. In the File name box, accept the suggested name or type a new name for the workbook.
  2. In the Save as type list, click the file format that you know you can open in the other program.
    1. The file formats that are available vary, depending on what type of sheet is active (a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.), chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.), or other type of sheet). For information about supported file formats, see File formats that are supported in Excel.
    2.  Tip   If needed, click the arrows to scroll to file formats that are not visible in the list.

  3. Click Save.

Top of Page Top of Page

Save a file in the Excel 2007 file format

You can save any file format that you can open in Excel 2007 in the current Excel Workbook file format (.xlsx). By doing this, you can use the new features of Excel 2007, such as the larger grid, that are not supported by other file formats.

 Note   When you save a workbook that was created in an earlier version of Excel as an Excel 2007 workbook, some formats and features may not be retained. For information on unsupported Excel 97-2003 features, see Excel 97-2003 features that are not supported in Office Excel 2007.

  1. Open the workbook that you want to save as an Excel 2007 workbook.
  1. Click the Microsoft Office Button Button image, and then click Save As.
  1. In the File name box, accept the suggested name or type a new name for the workbook.
  2. In the Save as type list, do one of the following:
    • If you are saving a workbook that was created in an earlier version of Excel, and the workbook contains macros that you want to retain, click .xlsm.
    • If you want to save the workbook as a template, click .xltx.
    • If you are saving a workbook that was created in an earlier version of Excel, the workbook contains macros that you want to retain, and you want to save the workbook as a template, click .xltm.
    • If you want to save the workbook in the current Excel Workbook file format, click .xlsx.
    • If you want to save the file in the new binary file format, click .xslb.
    • For more information about file formats, see File formats that are supported in Excel.
  3. Click Save.

Top of Page Top of Page

Change the default file format for saving

You can change the file type that is used by default when you save a workbook.

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Save category, under Save workbooks, in the Save files in this format box, click the file format that you want to use by default.

Top of Page Top of Page

Add the Save As command to the Quick Access Toolbar

The Save As command is not available as a button on the Microsoft Office Fluent user interface Ribbon. You can, however, add the command to the Quick Access Toolbar.

Quick Access Toolbar

  1. Click the Microsoft Office Button Button image.
  2. Right-click Save As, and then click Add to Quick Access Toolbar.

Top of Page Top of Page

 
 
Applies to:
Excel 2007