# 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

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

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.

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.

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.

Step 5:

• We will get a new workbook named Copied Result Workbook with our previous data.

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

Step 3:

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

### 3. Copy Multiple Sheets Using Dragging in Excel

Step 1:

• Open the source and target workbooks.
• First, arrange the two workbooks horizontally.

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.

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