How do you copy multiple sheets in Excel?

Excel plays a great role for professionals. Sometimes we get stuck in Excel. Lots of functions and formulas for different problems. But for some problems, there are no functions or

How do you copy multiple sheets in Excel?

Excel plays a great role for professionals. Sometimes we get stuck in Excel. Lots of functions and formulas for different problems. But for some problems, there are no functions or formulas. We solve these problems in other ways. Here we will describe how to copy multiple sheets in Excel to a new workbook. No exact formula exists in Excel for this problem.

Here, we will have a data set of two sheets for presentation purposes. Data on these sheets are not very significant. We introduced that data so that you can understand it easily.


Table of Contents hideDownload Practice Workbook3 Methods to Copy Multiple Sheets in Excel to New Workbook1. Copy Multiple Sheets Using Move or Copy Function in Excel2. Copy Multiple Sheets Using Ribbon Shortcut in New Workbook3. Copy Multiple Sheets Using Dragging in ExcelThings to RememberConclusionFurther Readings

Download Practice Workbook

Download this practice sheet to exercise while you are reading this article.

How to Copy Multiple Sheets in Excel to New Workbook.xlsx


3 Methods to Copy Multiple Sheets in Excel to New Workbook

To Copy Multiple Sheets in Excel, we will describe three ways.

1. Copy Multiple Sheets Using Move or Copy Function in Excel

We can copy multiple sheets in Excel using the Move or Copy function.

Step 1:

  • First, create a workbook with 2 sheets in our Dataset named Data 1 and Data 2.
Copy Multiple Sheets Using Move or Copy Function in Excel

Step 2:

  • Select the worksheets*.

*Note: If the worksheets that you plan to select are adjacent, then holding SHIFT down and selecting the first and last worksheet will allow you to select them all. If your worksheets are non-adjacent, then hold down CTRL and click on your desired selections.

  • Right-click the mouse and will see a Pop-Up. Select Move or Copy.
Copy Multiple Sheets Using Move or Copy Function in Excel

Step 3:

  • Another Pop-Up will appear called Move or Copy. Under the To book section, you will find a downward sign.

Step 4:

  • From the To book select a new book (see in point 1 of the following image).
  • Tick the Create a copy (see in point 2 of the following image). Now, press OK.
Copy Multiple Sheets Using Move or Copy Function in Excel

Step 5:

  • We will get a new workbook named Copied Result Workbook with our previous data.
Copied Result after Move or Copy function

Similar Readings:

  • How to Copy Excel Sheet to Another Sheet with Same Format
  • Copy a Sheet in Excel (5 Ways)
  • Copy and Paste in Excel Without Changing the Format

2. Copy Multiple Sheets Using Ribbon Shortcut in New Workbook

Step 1:

  • Select Data 1 and Data 2 sheets using Ctrl.

Step 2:

  • Go to Home from the ribbon.
  • Then go to Format from the ribbon and will see a drop-down.
  • Select Move or Copy Sheet from the drop-down.
Copy Multiple Sheets Using Ribbon Shortcut in New Workbook

Step 3:

  • A Pop-Up will appear called Move or Copy. Under the To book section, you will find a downward sign.
Copy Multiple Sheets Using Ribbon Shortcut in New Workbook

Step 4:

  • From the To book select Copied Result Workbook (see in point 1 of the image).
  • Tick the Create a copy (see in point 1 of the image). Then press OK.

Step 5:

  • We will get new sheets on the workbook Copied Result Workbook with our previous data copied on this workbook.
  • Also, sheet names are changed as previously same-named sheets exist here.
Copy Multiple Sheets Using Ribbon Shortcut in New Workbook

3. Copy Multiple Sheets Using Dragging in Excel

Step 1:

  • Open the source and target workbooks.
  • First, arrange the two workbooks horizontally.
Copy Multiple Sheets Using Dragging in Excel

Step 2:

  • From the source workbook, click the Data 1 sheet tab that we like to Copy.
  • Hold down the Ctrl key and drag the sheet to the target workbook.

Step 3: We see that a new sheet is added named Data 1 (3) to the target workbook.

Copy Multiple Sheets Using Dragging in Excel

Things to Remember

Keep a sharp eye on the Pop-Up and drop-downs. If you do not select the right option we will not get desired output.


Conclusion

Here we described three methods to copy multiple sheets to a new workbook. We showed the easiest methods that you can catch easily.


Further Readings

  • How to Copy a Worksheet in Excel (5 Smart Ways)
  • Copy Worksheet to Another Workbook Without Reference in Excel‌
  • How to Copy Excel Sheet to Another Sheet (5 Ways)
  • Excel VBA to Copy Multiple Sheets to New Workbook

Video liên quan