How to Change the Default Saving Format of Microsoft Excel

Date:2019-8-15 Author:Cordelia

When you create a new Excel file and want to save it for the first time, it can’t be saved directly but requires you to choose the location and format for saving. If you don’t have any special need to meet, you can let the format stay as default, which is Excel Workbook (*.xlsx), of course. Otherwise it’s necessary to choose a proper format in Save as type before saving the file. To avoid repetitive operations, I’d like to share the tip of changing the default format of Excel in case there’s any special situation requires you to save the file in a format other than XLSX every time.

How to Change the Default Saving Format of Microsoft Excel

Open any of your Excel files, switch to File tab.

How to Change the Default Saving Format of Microsoft Excel

Choose Options in the left sidebar.

How to Change the Default Saving Format of Microsoft Excel

Click saving in in Excel Options window. Find the options of Save files in this format in Save workbooks section. As shown in the picture below, the current default format for saving files is Excel Workbook (*.xlsx).

How to Change the Default Saving Format of Microsoft Excel

Click the choice box to enable the drop-down list. Choose the format according to your actual situation. If you want this file can be edited by former versions of Excel, choose Excel 97-2003 Workbook (*.xls).

How to Change the Default Saving Format of Microsoft Excel

Click OK to apply the setting to Excel. You’ll see the result next time saving a new file, the default type will show as the format you selected.

How to Change the Default Saving Format of Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

3 responses to “How to Change the Default Saving Format of Microsoft Excel”

  1. vurtil opmer says:

    Enjoyed examining this, very good stuff, thanks.

  2. vurtilopmer says:

    I am continually invstigating online for posts that can help me. Thx!

  3. Holley says:

    Its not my first time to pay a quick visit this website, i am visiting this web site dailly and take fastidious information from here daily.

Leave a Reply to vurtilopmer Cancel reply

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