Change the file format for saving workbooks in Excel for Mac

If you routinely share files with someone using an earlier version of Excel, set Excel to save your workbooks to a more convenient format.

  1. On the Excel menu, click Preferences.

  2. Under Sharing and Privacy, click Compatibility.

  3. On the Save files in this format menu, select the file format that you want to use.

    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 Excel or another spreadsheet program.

See also

File formats supported in Excel for Mac

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×