6-Ways to Duplicate a Worksheet in MS-Excel

30/04/2019
No Comments
Share

6-Ways to Copy a Worksheet in MS-Excel:

6-Ways to Copy or 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: Copy or Duplicate One Worksheet by Copying:

  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.
6-Ways to Duplicate a Worksheet in MS-Excel
6-Ways to Duplicate a Worksheet in MS-Excel

Method-2: Copy or Duplicate a Worksheet:

  1. Click and hold down the left mouse button on any sheet tab, then also press and hold down the Ctrl key.
  2. 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:

  1. 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.
  2. 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.
  3. 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:

  1. 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.
  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.

Method-5: Copy or Duplicate All Worksheets:

  1. Right click on any “Sheet tab”
  2. Then click “Select All Sheets”
  3. Again, right click on any “Sheet tab”,
  4. Then click “Move or Copy” (or drag and drop the sheet as explained above)
  5. Select the sheet that you want to copy before any sheet or select move to end
  6. Now select the “Create a copy”
  7. Then click ok.

Method-6: Copy or Duplicate a Worksheet from the Home Tab:

  1. Go to the home tab
  2. Then click on the Format in the Cell group
  3. Then click “Move or Copy Sheet” (or drag and drop the sheet as explained above)
  4. Select the sheet that you want to copy before any sheet or select move to end
  5. Now select the “Create a copy”
  6. Then click ok.

Related Posts: