6-Ways to Duplicate a Worksheet in MS-Excel:
6-Ways to Duplicate a Worksheet in MS-Excel:
6-Ways to Duplicate a Worksheet: There are several ways to duplicate the worksheet in excel using the shortcut keys or other commands in excel. So, learn all of the following methods.
Method-1; Duplicate a Worksheet:
- Click and hold down the left mouse button on any sheet tab, then also press and hold down the Ctrl key.
- After that, drag left or right over the sheet tabs and drop wherever you want to place the duplicate worksheet.
Method-2; Duplicate the Selected Worksheets:
- To duplicate more than one worksheet at a time, press and hold down the Ctrl key and click on the sheet tabs that you want to select.
- Now release the Ctrl key and click and hold down the left mouse button on any sheet tab, then also press and hold down the Ctrl key.
- After that, drag the mouse left or right over the sheet tabs and drop wherever you want to place the duplicate worksheets.
Method-3; Duplicate Some or All Worksheets:
- First, you should select some series of sheets. For example, click the sheet tab where you want to start from similarly, click the sheet tab where you want to stop.
- Now click and hold down the left mouse button on any sheet tab, then also press and hold down the Ctrl key.
- After that, drag the mouse left or right over the sheet tabs and drop wherever you want to place the duplicate worksheets.
Method-4; Duplicate All Worksheets:
- Right click on any “Sheet tab”
- Then click “Select All Sheets”
- Again, right click on any “Sheet tab”,
- Then click “Move or Copy” (or drag and drop the sheet as explained above)
- Select the sheet that you want to copy before any sheet or select move to end
- Now select the “Create a copy”
- Then click ok.
Method-5; Duplicate One Worksheet by Copying:
- Right click on any “Sheet tab”
- Then click “Move or Copy” (or drag and drop the sheet as explained above)
- Select the sheet that you want to copy before any sheet or select move to end
- Now select the “Create a copy”
- Then click ok.
Method-6; Duplicate a Worksheet from the Home Tab:
- Go to the home tab
- Then click on the Format in the Cell group
- Then click “Move or Copy Sheet” (or drag and drop the sheet as explained above)
- Select the sheet that you want to copy before any sheet or select move to end
- Now select the “Create a copy”
- Then click ok.
