How to Save Multiple Sheets in Excel (6 Ideal Methods)

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.

how to save multiple sheets in excel


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.

how to save multiple sheets in excel

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

how to save multiple sheets in excel

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.

how to save multiple sheets in excel

  • After that, go to the File tab.

  • Later, click on Save. This will save the changed data of corresponding sheets.

how to save multiple sheets in excel

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.

how to save multiple sheets in excel

  • 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


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

how to save multiple sheets in excel

  • Select Export and double click on Create PDF/XPS Document.

  • The save window will appear. Name your file and click on Publish.

how to save multiple sheets in excel

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

how to save multiple sheets in excel

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.

how to save multiple sheets in excel

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

how to save multiple sheets in excel

  • Let’s open some sheets for better understanding. The following image refers to sheet001.

  • And the next one is the sheet002

how to save multiple sheets in excel

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

how to save multiple sheets in excel

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

how to save multiple sheets in excel

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

how to save multiple sheets in excel


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

Meraz Al Nahian

Meraz Al Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo