Top 5 Different Ways to Copy or Move Sheets in Excel
Below are the five ways of copying a sheet in Excel.
#1 Copy Sheet by Dragging Method
#2 Copy Sheet by Right- Click
It is also the easiest way to copy or make a duplicate sheet in Excel using a mouse. Below are the steps:
First, click on the sheet tab (Sheet1) that we want to copy. Next, you may refer to the below screenshot. Now, press the “Ctrl” key and drag the Sheet1 where we want to place it then. It will create a copy of the Sheet1 with the name of Sheet1 (2) as per the below screenshot.
Step 1: We must first right-click on the sheet tab. It will open a drop-down list of options. Next, click on the “Move or Copy” option from the drop-down list.
Step 2: As a result, it will open the “Move or Copy” dialog box again. Refer to the below screenshot.
Step 3: Select the option under the “Before Sheet” section where we want to move or copy the sheet (Sheet1). Here, we want to copy the sheet at the end of the sheets. Hence, we selected the last option, “(move to end).” Tick on the box “Create a copy.” Click on “OK.”
Step 4: It will create a copy of Sheet1 like the below screenshot.
#3 Copy a Sheet by Using Excel Ribbon
For copying a sheet by using this method, follow the below steps:
Step 1: First, go to the “HOME” tab. Click on the “Format” option under the “Cells” section shown below screenshot (denoted by a red box).
Step 2: This will open a drop-down list of options. Click on the “Move or Copy Sheet” option, as shown in the below screenshot.
Step 3: Consequently, this will open a “Move or Copy” dialog box again, as shown below.
Follow the same steps under the copy sheet by right–click selection.
#4 Copy Excel Sheet from Another Workbook
If we have made some work on the Excel workbook and have to share some part of it or one sheet with someone. We do not want to share the whole workbook with him due to some critical and confidential information. In that case, we can use the option of copying the sheet from our workbook into a separate workbook.
The steps are the same, which we learned in the above section.
Step 1: We must first right-click on the sheet tab we want to copy and then choose the option “Move or Copy” from the drop-down list.
Step 2: The “Move or Copy” dialog box will appear in the screenshot below. Click on “To Book” and select the target file.
Step 3: To copy the sheet into a new workbook, select a new book. Then, under the “Before sheet” section, choose the destination where we want to place a copy of the sheet. Also, tick on the “Create a copy” checkbox, then click on “OK.”
#5 Copy Multiple Sheets in Excel
We also can copy multiple Excel sheets. Follow the below steps:
Step 1: For selecting adjacent sheets, we must click on the first sheet tab, press the “SHIFT” key, and click on the last sheet tab.
Step 2: For alternate or non-adjacent sheets, click on the first sheet tab, press the “CTRL” key, and click the other sheets tab, which we want to copy.
Step 3: After selecting multiple sheets, press a right-click. A dropdown list will open. First, choose the “Move or Copy” option. Then, follow the same steps as we discussed in the above section.
Things to Remember
When we open the “Move or Copy” dialog box, under the “To book” section, Excel displays only the open workbooks in the drop-down list. Hence, we must open the destination workbook before copying the sheet.
Recommended Articles
This article is a guide on How to Copy Sheet in Excel. Here, we discuss the top 5 methods to copy sheets, including dragging, right-click, and ribbon. We also discuss how to copy multiple sheets in Excel and practical examples and a downloadable template. You may learn more about Excel from the following articles: –
- Excel Group WorksheetHiding Column in ExcelDivision in ExcelRegression Analysis ExcelCAGR Formula in Excel
