The article will show you some different methods on how to save multiple sheets in Excel. Saving your file is mandatory because if you don’t, you will lose your data or information. Although there are some other ways to recover unsaved files, it’s safe and convenient to save an Excel file. This way, you can store data from your Excel sheet permanently.
In this article, we will be using the following information to illustrate the methods. The data contains the names of some guys, their Residence and Company Name where they work. The information is not the same for all the sheets.
Save Multiple Sheets in Excel: 6 Ways
1. Using Keyboard Shortcut to Save Multiple Sheets in Excel
Using the keyboard shortcut is the most common method of saving multiple sheets in Excel. You probably know about this from your childhood. Let’s see the process below.
Steps:
- Make necessary changes in any of your sheets.
- Say, I added and removed data from the dataset and keyboard shortcut sheets.
Here is the dataset sheet.
The keyboard shortcut sheet.
- Now press CTRL+S and close the Excel file.
- After that, open the file again.
Finally, you can see your saved data in both sheets.
Thus you can easily save multiple sheets in Excel using the CTRL+S shortcut.
Read More: How to Save a Worksheet in Excel to a Separate File
2. Saving Multiple Excel Sheets from File Menu
Another way to save multiple sheets is to use the Save options from the File menu. Let’s go through the procedure below.
Steps:
- Make some necessary changes in your Excel sheets.
- In my file, I added a row in the dataset sheet and deleted a cell value from the file menu.
The dataset sheet.
Also, the file menu sheet.
- After that, go to the File tab.
- Later, click on Save. This will save the changed data of the corresponding sheets.
Thus you can save multiple sheets with the help of the File menu.
Read More: How to Save Multiple Excel Sheets as One File
3. Use of Move or Copy Feature to Save Multiple Sheets in a New Workbook
If you want to transfer the data of some of your sheets to a new Excel workbook, you need to save them to that workbook. Let’s see the instructions below.
Steps:
- First, select the sheets that you want to save in a new Excel workbook. In case you don’t know how to select several Excel sheets, just hold the CTRL key and click on your desired sheets.
- After that, right-click on the name of any of those sheets.
- Select Move or Copy.
- In my workbook, I selected ‘new workbook’ and ‘pdf’
- A dialog box will show up. Select (new book) in the To book: section and check Create a copy.
- After that, click OK.
- Now you will see these 2 sheets in a new workbook. Press CTRL+S to save them in that workbook.
Thus you can save multiple sheets in a new workbook.
Read More: How to Save a Worksheet in Excel
4. Utilizing Export Command to Save Multiple Sheets as PDF
We can also save multiple sheets by using the Export command from the File menu. It will show these sheets saved as PDF files. Let’s see the instructions below.
Steps:
- First, select the sheets that you want to save in a new Excel workbook. In case you don’t know how to select several Excel sheets, just hold the CTRL key and click on your desired sheets.
- In my workbook, I selected ‘export’ and ‘file menu’
- After that, I selected the File
- Select Export and double-click on Create PDF/XPS Document.
- The save window will appear. Name your file and click on Publish.
- After that, open the PDF You will see the 2 selected sheets in that PDF file.
The file menu sheet is on the 1st page.
The export sheet is on the 2nd page.
Thus you can save multiple sheets in a new PDF file.
Read More: How to Save Excel File in XLSX Format
5. Use of Save As Command to Save Multiple Sheets with New Extension
You can convert and save multiple sheets to a new file extension. This is helpful if you want to work with your data in different file extensions. Let’s have a look at the description below.
Steps:
- First, select the File
- After that, go to Save As >> Browse.
- The save window will appear. Name your file and select the File Extension of your choice. For this method, I selected .htm Extension.
- Click on Save.
- After that, your Excel file will be converted and saved as an HTML. It will also create a new folder and store all the sheets of your workbook.
- Let’s open some sheets for better understanding. The following image refers to sheet001.
- And the next one is the sheet002
Thus you can save multiple sheets as a new file extension.
Read More: How to Save Multiple Tabs in Excel as Separate Files
6. Applying VBA to Save Multiple Sheets in Excel
VBA can also be applicable for saving multiple Excel sheets. Let’s go through the procedure below.
Steps:
- First, go to Developer >> Visual Basic
- After that, the VBA editor will show up. From Insert >> select Module
- Type the following code in the VBA module.
Sub SaveMultipleSheets()
ThisWorkbook.Save
End Sub
Here, we save our Excel file with .Save property.
- Click on the Run button.
- Click on Run in the Macros window to save the multiple sheets of your workbook.
Thus you can save multiple sheets by VBA.
Practice Section
In this section, I’m giving you the dataset so that you can make your own and practice these methods.
Download Practice Workbook
Conclusion
In the end, we can conclude with the statement that you will learn some effective methods on how to save multiple sheets in Excel. If you have any questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.
