Click on the Move or Copy Sheet option, as shown in the below screenshot. Step 2: This will open a drop-down list of options.Click on the FORMAT option under the Cells section shown as below screenshot (denoted by a red box). Step 4: It will create a copy of Sheet1 like the below screenshot.įor copying a sheet by using this method, follow the below steps:.Tick on the box “Create a copy.” Click on OK. Here I want to copy the sheet at the end of the sheets hence selected the last option, which is a move to end. Step 3: Select the option under the Before Sheet section, where you want to move or copy the sheet (Sheet1).Step 2: This will again open the Move or Copy dialog box. ![]() Click on the Move or Copy option from the drop-down list. ![]() It will open a drop-down list of options. This is also the easiest way to copying or making a duplicate sheet in excel using a mouse. Press the CTRL key and drag the Sheet1 where you want to place it then, this will create a copy of the Sheet1 with the name of Sheet1 (2) as per the below screenshot.Click on the sheet tab (Sheet1) that you want to copy.
0 Comments
Leave a Reply. |