Save a Workbook in another File Format When you save an Excel 2013 Workbook, by default it saves in the .xlsx format. Excel 2013 supports saving in other formats, but whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved. File Formats (File Types) that are supported in Excel 2013 − Excel File Formats Text File Formats Other File Formats Excel File Formats Format Extension Description Excel Workbook .xlsx The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). Strict Open XML Spreadsheet .xlsx An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code) .xlsm The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm) Excel Binary Workbook .xlsb The binary file format (BIFF12) for Excel 2007-2013. Template .xltx The defa
Change in Charts Group The Charts Group on the Ribbon in MS Excel 2013 looks as follows − You can observe that − The subgroups are clubbed together. A new option ‘Recommended Charts’ is added. Let us create a chart. Follow the steps given below. Step 1 − Select the data for which you want to create a chart. Step 2 − Click on the Insert Column Chart icon as shown below. When you click on the Insert Column chart , types of 2-D Column Charts , and 3-D Column Charts are displayed. You can also see the option of More Column Charts . Step 3 − If you are sure of which chart you have to use, you can choose a Chart and proceed. If you find that the one you pick is not working well for your data, the new Recommended Charts command on the Insert tab helps you to create a chart quickly that is just right for your data. Chart Recommendations Let us see the options available under this heading. (use another word for heading) Step 1 − Select the Data from the worksheet. Step 2 − C