While working in Microsoft Excel, you might need to save files in a format so they won’t change. The default file format in excel is XLSX format. This format is generally accessible with other applications. It also can use and save all types of functions without VBA Macros. In this article, I will share how to save excel file in XLSX format.
4 Simple Methods to Save Excel File in XLSX Format
In the following article, I am explaining 4 simple and easy methods to save file in XLSX format.
1. Utilize Save as Option to Save Excel File in XLSX Format
XLSX format takes more space than other formats but it’s a universal format of excel. With the help of Save as options, we will save the file in XLSX format.
Steps:
- Go to the “File” option from the home ribbon.
- Choose “Save as” and your desired location to save the file.
- Give the name of your file in the “File name” section.
- From the drop-down list of “Save as type” choose “Excel Workbook”.
- Press Save to continue.
- This way you can save your file to XLSX format easily.
Read More: Excel VBA Save as File Format (12 Suitable Examples)
2. Keyboard Shortcut to Save Excel File in XLSX Format
You can also use the keyboard shortcut to save an workbook to XLSX format in excel. Follow the steps below-
Steps:
- While in the workbook press Ctrl+S.
- In the “Save as” window Name the workbook and choose “Excel Workbook”.
- Click Save.
- Thus your excel book will be ready in XLSX format. Simple isn’t it?
Read More: Excel VBA to Save File with Variable Name (5 Examples)
Similar Readings
- How to Save VBA Code in Excel (3 Suitable Methods)
- Excel VBA to Print As PDF and Save with Automatic File Name
- Fix Excel Not Responding and Save Your Work
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- How to Undo Changes in Excel after Save and Close (2 Easy Methods)
3. Use Excel Options to Save Excel File in XLSX Format
To save files always in XLSX format you can choose by default from the built-in feature of excel options.
Steps:
- Click the “File” option from the top of the workbook options.
- Choose Options to open a new window.
- From the new window click “Save” and in the “Save file in this format” choose “Excel workbook”.
- Press OK to continue.
- Now if you click on the “Save” icon from the workbook it will automatically save your excel workbook in XLSX format.
Read More: Excel VBA to Save as File Using Path from Cell (With Quick Steps)
4. Utilize Quick Access Toolbar to Save Excel File in XLSX Format
This is the simplest way to save an worksheet file in xlsx format or other formats of your choice. Utilizing the quick access toolbar you can save your file to XLSX format just with a single click. Stay tuned.
Steps:
- Press the “File” option to go to “Quick Access Toolbar”.
- Click options to open a new window.
- From various options first, select “Quick Access Toolbar”.
- In the “Choose commands from” select “All Commands”.
- Scroll down and select “Save As Other Format” and click “Add” to enable this option.
- Hit the OK.
- As you can see at the top of the workbook we have an icon to save files in the desired format.
- Click the icon and choose “Save as Another File Type”.
- In the “Save as” window name your workbook and select “Excel Workbook” to get the file in desired format.
- Now your file is saved in xlsx format.
Read More: How to Save Excel File with Password
Things to Remember
- The “Excel Workbook” format is actually the XLSX format in excel.
Conclusion
In this article, I have tried to cover the simple steps to save file in XLSX format in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.
Related Articles
- [Fixed!] Excel CSV File Not Saving Changes (6 Possible Solutions)
- How to Save Multiple Tabs in Excel as Separate Files (5 Easy Methods)
- Excel VBA Macro to Save PDF in Specific Folder (7 Ideal Examples)
- VBA Code for Save Button in Excel (4 Variants)
- How to Save a Macro for All Workbooks in Excel (with Easy Steps)
- How to Save Excel as PDF Landscape (With Quick Steps)