How to Save Multiple Sheets in Excel – 6 Methods

The dataset contains names, Residence and Company Name.

how to save multiple sheets in excel

Method 1 – Using a Keyboard Shortcut to Save Multiple Sheets in Excel

Steps:

  • Data was added and removed from the dataset:

This is the keyboard shortcut sheet:

how to save multiple sheets in excel

  • Press CTRL+S and close the Excel file.
  • Open the file again.

Data  was saved in both sheets.

how to save multiple sheets in excel

 

Read More: How to Save a Worksheet in Excel to a Separate File


Method 2 – Saving Multiple Excel Sheets using the File Menu

Steps:

  • A row was added to the dataset and a cell value was deleted.

This is the dataset sheet.

This is the file menu sheet.

how to save multiple sheets in excel

  • Go to the File tab.

  • Click Save.

how to save multiple sheets in excel

 

Read More: How to Save Multiple Excel Sheets as One File


Method 3 – Using the Move or Copy Feature to Save Multiple Sheets in a New Workbook

Steps:

  • Select the sheets that you want to save in a new Excel workbook. Select different sheets holding CTRL and clicking the sheets.
  • Right-click a sheet.
  • Select Move or Copy.
  • Here, ‘new workbook’ and ‘pdf

  • Select (new book) in To book: and check Create a copy.
  • Click OK.

how to save multiple sheets in excel

  • The 2 sheets will be displayed in a new workbook.
  • Press CTRL+S to save.

Read More: How to Save a Worksheet in Excel


Method 4 – Utilizing the Export Command to Save Multiple Sheets as PDF

Steps:

  • Select the sheets you want to save in a new Excel workbook.
  • Here, ‘export’ and ‘file menu
  • Go to File.

how to save multiple sheets in excel

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

  • Name your file and click Publish.

how to save multiple sheets in excel

  • Open the PDF: you will see the 2 selected sheets.

The file menu sheet is on the 1st page.

how to save multiple sheets in excel

The export sheet is on the 2nd page.

Read More: How to Save Excel File in XLSX Format


Method 5 – Use the Save As Command to Save Multiple Sheets with a New Extension

Steps:

  • Go to File.

  • Select Save As >> Browse.

how to save multiple sheets in excel

  • Name your file and select a File Extension. Here, .htm Extension.
  • Click Save.

Your Excel file will be converted and saved as HTML. It will also create a new folder and store all the sheets of your workbook.

how to save multiple sheets in excel

  • This is sheet001.

  • This is sheet002

how to save multiple sheets in excel


Method 6 – Applying VBA to Save Multiple Sheets in Excel

Steps:

  • Go to Developer >> Visual Basic

  • In the VBA editor, select Insert >> choose Module

how to save multiple sheets in excel

  • Enter the following code in the VBA module.
Sub SaveMultipleSheets()
ThisWorkbook.Save
End Sub

  • Save the Excel file using the .Save property.

how to save multiple sheets in excel

  • Click Run in the Macros window to save the multiple sheets.

 


Practice Section

Practice here.

how to save multiple sheets in excel


Download Practice Workbook


Related Articles


<< Go Back to How to Save Excel File | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo