How to always save a file in XLS format in Microsoft Excel 2013?

This article will explain how the users can always save the excel workbook in XLS format in Microsoft Excel 2013.

How to always save a file in XLS format in Microsoft Excel 2013?

The users can set the default Save As format of the excel workbook to XLS format (Excel 97-2003) format. Follow the below steps to know how to save the excel workbook always in XLS format.

1. Launch Microsoft Excel 2013.

2. Click “File” -> “Options” in Excel.

3. This will display the Excel Options Dialog. In the left sidebar of the “Excel Options”, click Save. In the “Save workbooks” group, Select “Excel 97-2003 workbook (*.xls)” from the Save files in this format DropDownList.

How to always save a file in XLS format in Microsoft Excel 2013?

4. Click OK. Now, when you save the excel workbook, it saves in the XLS format by default.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...