How to Save Excel File in XLSX Format (4 Easy Methods)

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.

Utilize Save as Option to Save Excel File in XLSX Format

  • Choose “Save as” and your desired location to save the file.

Utilize Save as Option to Save Excel File in XLSX Format

  • 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.

Utilize Save as Option to Save Excel File in XLSX Format

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.

Keyboard Shortcut to Save Excel File in XLSX Format

  • Thus your excel book will be ready in XLSX format. Simple isn’t it?

Keyboard Shortcut to Save Excel File in XLSX Format

Read More: Excel VBA to Save File with Variable Name (5 Examples)


Similar Readings


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.

Use Excel Options to Save Excel File in XLSX Format

  • 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.

Use Excel Options to Save Excel File in XLSX Format

  • 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”.

Utilize Quick Access Toolbar to Save Excel File in XLSX Format

  • Click options to open a new window.

Utilize Quick Access Toolbar to Save Excel File in XLSX Format

  • 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

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo