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

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...