HomeMicrosoft OfficeExcelHow to copy multiple sheets in Excel ?.

How to copy multiple sheets in Excel ?.

There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Microsoft Excel. In this blog post, lets see how to do it in Microsoft Excel 2016.

How to copy multiple sheets in Excel?

1. Select the worksheets that you want to copy. Press the “Ctrl” key and click on the worksheet names in the sheet tab that can be found in the bottom of the excel to multi-select.

2. Right click on the sheet tab and select “Move or Copy” from the Context menu.

image

3. In the Move or Copy dialog box, select the settings as shown in the screenshot. Select the workbook and “move to end” options and click the OK button.

image

4. You should immediately see the worksheet being copied.

image

    1 Comment

  1. User Avatar
    Sandhya
    April 15, 2023
    Reply

    Learning to replicate several Excel sheets is easy.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021