How to make a copy of an Excel sheet

The typical copy-paste method is not appropriate when you are going to copy an entire excel worksheet. Something special needs to do. Do you know what is that special process? If not then this content is for you. In this content, I will guide you on how to make a copy of an Excel sheet.

How to make a copy of an Excel sheet

There are two processes for making a copy of an excel sheet. First, copy all cells and paste them onto another sheet.  But it does not work properly. All column widths and row heights will be as default so you need to customize it again. So, I will never suggest anyone follow this process. Making a duplicate copy of an excel sheet is easier than this way. I will share the second and also the third process to copy the excel sheet to a new sheet. Follow the instructions below to learn to make a copy of an Excel sheet.

Read More: How to calculate grade in Excel sheet using VLOOKUP function

Copy a sheet within the same workbook

From the worksheet tab

• Open the Excel sheet that you make a copy of.
• Right-click on the worksheet tab and select Move or Copy.

• Select (move to end) and click to check the box Create a copy.

• Click OK to complete the task.

The entire worksheet is copied and the worksheet moved to the last worksheet tab. If you want to move to any specific place do not select (move to end), select the tab where you want to move it. If you do not select Create a copy, the worksheet will move.

By using dragging

It is the easiest method of copying a worksheet within the same workbook. Follow the instruction below to do the task.

• Press and hold the Ctrl key on your keyboard.
• Use your mouse cursor, select the worksheet and drag it to where you want to copy in the workbook.

From the Ribbon

You can also do the same job with the ribbon.

• Open the worksheet that you want to move or copy.
• Go to the Home tab.
• Click the format button from the cells group and select Move or Copy Sheet.

• You can do the remaining steps as described above.

Read More: How to customize quick access toolbar in Excel?

Copy a sheet to the different workbook

From the worksheet tab

Sometimes, you may need to copy or move a worksheet to a different workbook. That is also simple and easy to do. Follow the below instructions.

• Open the Excel sheet that you make a copy of.
• Right-click on the worksheet tab and select Move or Copy.
• Click on the drop-down menu of To book. [both workbooks should be open at a time]
• Select the workbook from the drop-down menu where you want to make a copy.

• Select Create a copy if you want to copy. If you want to move don’t click on it.
• Click OK to complete the task.

By using dragging

You can also move or copy a worksheet to another workbook by dragging, need to be a little bit tricky. Follow the steps below to do the task.

• Go to the View tab Window group.
• Select View Side by Side.
• Press and hold the Ctrl key on your keyboard.
• Use your mouse cursor, select the worksheet and drag it to where you want to copy in the workbook.

From the Ribbon

You can also do the same job with the ribbon.

• Open the worksheet that you want to move or copy.
• Go to the Home tab.
• Click the format button from the cells group and select Move or Copy Sheet.

• You can do the remaining steps as described above.

How to copy multiple sheets at once

Copy multiple sheets within the same workbook

From the worksheet tab

• Press and hold the Ctrl key on your keyboard.
• Select all the worksheets that you want to move or copy.
• Click on the drop-down menu of To book. [both workbooks should be open at a time]
• Select the workbook from the drop-down menu where you want to make a copy.
• Click OK to complete the task.

By using dragging

• Press and hold the Ctrl key on your keyboard.
• Use your mouse cursor, select all the worksheets and drag it to where you want to copy into the workbook.

From the Ribbon

• press and hold the Ctrl key on your keyboard.
• Select all the worksheets that you want to move or copy.
• Go to the Home tab.
• Click the Format button from the cells group and select Move or Copy Sheet.
• You can do the remaining steps as described above.

Copy multiple sheets to the different workbook

From the worksheet tab

• Press and hold the Ctrl key on your keyboard.
• Select all the worksheets that you want to move or copy.
• Right-click on the worksheet tab and select Move or Copy.
• Click on the drop-down menu of To book. [both workbooks should be open at a time]
• Select the workbook from the drop-down menu where you want to make a copy.

• Click OK to complete the task.

By using dragging

• Go to the View tab in the Window group.
• Select View Side by Side.
• Press and hold the Ctrl key on your keyboard.
• Select all the worksheets that you want to move or copy.
• Use your mouse cursor, select the worksheet and drag it to where you want to copy in the workbook.

From the Ribbon

• press and hold the Ctrl key on your keyboard.
• Select all the worksheets that you want to move or copy.
• Go to the Home tab.
• Click the format button from the cells group and select Move or Copy Sheet.
• You can do the remaining steps as described above.

Why do you need to duplicate your worksheet

Working in Microsoft Excel has some basics. When you are going to work on a worksheet, you should not work on it for safety. Data can be changed by you. That is why it is the best practice to copy the entire worksheet to new places and start editing.

If you do so, there is no chance of damage or manipulation of existing data. That is why it is very important to know how to make a copy of an Excel sheet.

Dear readers, I hope, this content is helpful to you. If you have any more queries. Please feel free to comment below. I will try my best to reply to your comments as soon as possible. Thank You for being with us.