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 print title on every page in Microsoft Excel?
Most of the time we might end up having a long workbook with huge amount of data and they have lot o...
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...