How to Copy Multiple Sheets Multiple Times in Excel Office 365?
Tags: copymultiplesheetsin, kutoolsexceltutorial, kutools
Published: 2020-10-30 11:57:21

---
title: How to Copy Multiple Sheets Multiple Times in Excel Office 365?
published: true
date: 2020-10-30 09:30:36 UTC
tags: CopyMultipleSheetsin,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-copy-multiple-sheets-multiple-times-in-excel-office-365/
---

In this article, You will understand the Steps to **Copy Multiple Sheets Multiple Times in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Copy Multiple Worksheets:

To do this, you need to follow the below steps.

- [Open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that contains multiple sheets that you want to copy.
- For example, we have shown the multiple sheets in the below image, and we want to **copy the Grade sheet** multiple times.

![Multiple sheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Multiple-sheets.png)<figcaption id="caption-attachment-16517">Multiple sheets</figcaption>

- Go to the **Kutools Plus Tab** , **select** the **Worksheet** option, **choose** the **Copy Worksheets** option from the drop-down menu.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-25.png)<figcaption id="caption-attachment-16518">Kutools Plus Tab</figcaption>

- It will open the **Copy Multiple Worksheets Dialog Box**.
- **Copy the selected worksheets –** In this section, you need to select the sheets that you want to copy.
- **The number of copies –** Specify the number of copies using the drop-down button.
- **Insert copy worksheets –** You need to select the location of the copies from the given options.

### Note:

- If you check the Worksheet name checkbox will select all worksheets, else it will unselect all worksheets.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Hit-the-OK-button-3.png)<figcaption id="caption-attachment-16519">Hit the OK button</figcaption>

- Then, **click** the **OK** button. It will open the prompt box to remind you of the number of copies.
- You need to **click** the **OK** button to close this prompt box.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-box-11.png)<figcaption id="caption-attachment-16520">Prompt box</figcaption>

- At last, you can see that the selected sheets have been copied multiple times as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-47.png)<figcaption id="caption-attachment-16521">Output</figcaption>

## Verdict:

In the above article, you can easily understand the steps to **Copy Multiple Sheets Multiple Times in Excel Office 365** using **Kutools. ** Drop your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Print Pages in Reverse Order in Excel Office 365?](https://geekexcel.com/how-to-print-pages-in-reverse-order-in-excel-office-365/)
- [Fetch Values From Cells for Calculation in Excel Office 365!!](https://geekexcel.com/fetch-values-from-cells-for-calculation-in-excel-office-365/)