How to Copy Sheet in Excel

In this blog post, we will see how we can copy sheet in excel. To explain in detail, we will open new excel file which have 03 worksheets in it.

There are two methods by which we can copy the sheets:

1. By using Format command

2. By using Mouse Right Click

1. By using Format command:

In this method we use format command to copy the selected sheet. Following steps will give you clear idea about how we can copy the sheet in excel.

1. Select the sheet which we want to copy. (In this case “Sheet1”).

2. Go to “Home Tab”. Select format command under “Cells group”. Select option “Move or Copy Sheet”.

3. “Move or Copy” dialog box will open. Select the sheet in this dialog box before which we want to copy selected sheet. For example if we want to copy selected sheet before sheet3 then select “Sheet3” and Check the checkbox for “Create a Copy”.

4. We can see Selected Sheet (i.e. Sheet1) is copied before “Sheet3”.

5. Select “Move to end” option if we want to copy the selected sheet at the end of all sheets and Check the checkbox for “Create a Copy”.

6. We can see that selected sheet “Sheet1” is copied to end.

2. By Using Mouse Right Click:

1. Place the cursor on the sheet which we want to copy. (Sheet1 in our case). Press Mouse Right Click button. Select “Move or Copy” option from the list of appeared options.

2. “Move or Copy” dialog box will open. Select the sheet in this dialog box before which we want to copy selected sheet. For example if we want to copy selected sheet before sheet3 then select “Sheet3” and Check the checkbox for “Create a Copy”.

3. We can see Selected Sheet (i.e. Sheet1) is copied before “Sheet3”.

4. Select “Move to end” option if we want to copy the selected sheet at the end of all sheets and Check the checkbox for “Create a Copy”.

5. We can see that selected sheet “Sheet1” is copied to end.

If you have any queries on this topic then you can write in comment box below.