How to Copy a Sheet in Excel (5 Easy Ways)

Anyone may need a backup or copies of their sheet because sometimes in the same sheet we need to perform various tests, functions, etc. Datasheets can be correlated; we may need to create a new sheet depending on the existing one. Also, we may need a backup of our sheet to use later. In this article, I’m going to explain how to copy a sheet in Excel. You will know almost all possible ways of copying a sheet in Excel.

Download Practice Section

You can download the workbook to practice yourself.

Copying Sheet.xlsm

5 Easy Ways to Copy a Sheet in Excel

In my workbook, I used 2 sheets. These are Sales and Product.

Above dataset contains the data of Product, Sales and Order Date.

The Product Sheet contains the information of Sales Person, Product Name and Product Price.

Now, we will show you 5 easy ways to copy these sheets in Excel.

1. Copy a Sheet in Excel by Dragging

In the first method, we will show you how to copy a sheet by dragging it in Excel. You can use this method to copy a sheet within the same workbook and to another one.

1.1 Within Same Workbook

To copy an existing sheet within the same workbook in Excel by dragging follow the steps given below.

Steps:

Firstly, go to Sheet tabs and select the Sheet you want to copy. Here, we will select the Sales sheet.
Then, hold the Ctrl key.
After that, while holding the key drag the Sheet using your left mouse key or touchpad.

Now, drag it to where you want to place your copied Sheet.
Don’t forget to press Ctrl otherwise, it will move the sheet place and won’t copy.

1.2 To Another Workbook

To copy a sheet from one workbook to another by dragging, open both the workbooks from where you want to copy the dataset and the one where you want to copy. After that, go through the steps given below.

Steps:

Firstly, go to the Sheet tabs of the sheet from where you want to copy the dataset.
Next, select the Sheet you want to copy then hold the Ctrl key.

Now, drag it by using the left mouse key to another workbook Sheet tab.
Then, place the icon where you want to place the sheet.
Next, you can see the same Sheet in a different workbook.

Read more: How to Copy Excel Sheet to Another Sheet

2. Right-Click on Mouse to Copy an Excel Sheet

You can also copy an Excel sheet by Right-clicking on the mouse.

2.1 Within Same Workbook

Here, you will find the way to copy an Excel sheet within the same workbook by right-clicking on the mouse.

Steps:

In the beginning, select the Sheet then click on the right side of the mouse.
Now, select Move or Copy.

After that, a dialog box will pop up.
From there from the Before sheet select the sheet you want to copy.
Here, we have selected the Sales sheet.
Then, mark on the Create a copy.
Finally, click OK.

Thus, You will find the copied sheet Sales (2).

2.2 To Another Workbook

To copy Excel Sheet by right-clicking to another workbook follow the steps given below.

Steps:

To start with, select the Sheet then click on the right side of the mouse.
Then, select Move or Copy.

Next, a dialog box will pop up.
Now, from To book select the book name you want to place on your copied sheet.
From there from the Before sheet select the sheet you want to copy then mark on the Create a copy.
Here, we selected the workbook Book1 and the sheet Sales.
Finally, click OK.

Thus, you can copy a sheet to another workbook.

3. Use Ribbon to Copy a Sheet in Excel

Now, we will show you how you can use ribbon to copy a sheet in Excel.

3.1 Within Same Workbook

To copy a sheet using ribbon within the same workbook follow the steps given below.

Steps:

In the beginning, go to the Home tab >> expand Cells >> click on Format >> select Move or Copy Sheet.

Now, the Move or Copy Sheet dialog box will pop up.
After that, you can select the place where you want to put your copied sheet in the Before Sheet.

Here, we selected Sales so the copied sheet is placed before Sales as Sales (2).

3.2 To Another Workbook

To copy a sheet in another workbook using ribbon, follow the same steps shown above. Then, in the Move or Copy box follow the steps given below.

Steps:

From To book you can select the workbook where you want to place your copied sheet.
Now, you can select the place where you want to put your copied sheet from Before Sheet.
Here, we selected Book1 in To book and move to end in the Before sheet.
Finally, click on OK.

Thus, the Copied sheet of Sales will be now placed in a new workbook Book1.

Similar Readings:

4. Copy an Excel Sheet Using VBA

VBA can also be used to copy an Excel sheet. Follow the steps given below to do that.

Steps:

Firstly, select the sheet you want to copy.
Then, go to the Developer tab>> click on Visual Basic.

After selecting Visual Basic, the Microsoft Visual Basic Application window will pop up.
Now, click on Insert and select Module.

After that, in the Module write code to copy sheets in Excel.

Sub Copier()
Dim x As Integer
x = InputBox("How many copies do you want?")
For numtimes = 1 To x
ActiveWorkbook.Sheets("Product").Copy _
After:=ActiveWorkbook.Sheets("Product")
Next
End Sub

Code Breakdown

Firstly, we created a Sub Procedure named Copier and declared x as Integer.
Then, we inserted an InputBox.
After that, we used a For loop to copy the dataset.

Now, click on the Save button to save the code and go back to the Excel Workbook.

Then, go to the Developer tab >> click on Macros.

Afterward, a dialog box will pop up.
Here the macro we created is Copier. From Macros, you can select the workbook where you want to run the code.
Then, we selected my working workbook Copy a Sheet in Excel.
Finally, click on Run.

A new dialog box will pop up.
Here, it will show “How many copies do you want?” from where you can select the number of copies you want.
Then, click on OK.

Here, we selected 1.
Thus, it will show one copy of the Product sheet.

5. Duplicate a Sheet in Excel Web Version

In case anyone is using online Excel and wants to know how to copy a sheet there. Please follow the steps given below.

Steps:

To start with, select the sheet you want to copy then click on the right side of the mouse.

Now, select duplicate.

Finally, it will copy the sheet before to your selected sheet.

How to Copy Multiple Sheets in Excel

The method we used to copy a single sheet can be applied to copy multiple sheets. But for that, you will need to select multiple worksheets.

To select multiple sheets, you can use Shift or Ctrl. To use Shift, first select the first sheet while holding the Shift key select the last sheet. All sheets will be selected. On the other hand, to use Ctrl while holding Ctrl select the sheets you want to select it won’t select all sheets.