There are several ways to duplicate a worksheet in excel using the shortcut keys or other commands in excel. So, learn all of the following methods.
Method-1: Copy or Duplicate One Worksheet:
- 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-2: Copy or 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-3: Copy or Duplicate the Selected Worksheet:
- 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-4: Copy or 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-5: Copy or 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-6: Copy or 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.
Related Posts:
- Find Text using Navigation Pane in MS-Word:
- Bold, Italic, and Underline in MS-Word 2019, 2016…2007
- Recover Unsaved Document and Workbook in MS-Office 2019, 2016, 2013
- Take a Screenshot in Different Ways on Windows OS.
FAQ:
How to Duplicate Some or all Worksheets at a time in Excel?
1. First, you should select a 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.
2. Now click and hold down the left mouse button on any sheet tab, then also press and hold down the Ctrl key.
3. After that, drag the mouse left or right over the sheet tabs and drop wherever you want to place the duplicate worksheets.
How to Copy or Duplicate one Worksheet in Excel
1. Right-click on any “Sheet tab”
2. Then click “Move or Copy” (or drag and drop the sheet as explained above)
3. Select the sheet that you want to copy before any sheet or select move to end
4. Now select the “Create a copy”
5. Then click OK.
