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 names of some guys, their Residence and Company Name where they work. The information is not the same for all the sheets.
Download Practice Workbook
6 Ways to Save Multiple Sheets in Excel
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 Multiple Sheets in Excel to CSV (6 Easy Methods)
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 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 (5 Easy Methods)
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 in 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: Excel VBA: Save and Close Workbook (5 Suitable Examples)
Similar Readings
- Save Excel Files as Text Without Quotes (4 Methods)
- How to Save Excel as PDF without Cutting Off (4 Suitable Ways)
- Excel VBA: Create Invoice and Save PDF Format (with Quick Steps)
- Save Excel as CSV with Double Quotes (3 Simplest Methods)
- Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)
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 in a PDF file. 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 Multiple Excel Sheets as One PDF (2 Easy Methods)
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: Excel Macro to Save as PDF (5 Suitable Examples)
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.
Read More: How to Save a Worksheet in Excel (2 Handy Approaches)
Practice Section
In this section, I’m giving you the dataset so that you can make your own and practice these methods.
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.
Related Articles
- How to Save Macro to Personal Macro Workbook?
- How to save workbooks that contain Macros
- Excel VBA to Print As PDF and Save with Automatic File Name
- How to Save VBA Code in Excel (3 Suitable Methods)
- Fix Excel Not Responding and Save Your Work
- How to Undo Changes in Excel after Save and Close (2 Easy Methods)