Menu

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

0 Comments

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:

  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-2; Duplicate the Selected Worksheets:

  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-3; 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-4; 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-5; 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.

Method-6; 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.
JOIN OUR NEWSLETTER
I agree to have my personal information transfered to MailChimp ( more information )
Join over 3.000 visitors who are receiving our newsletter.
We hate spam. Your email address will not be sold or shared with anyone else.

Leave a Reply

Your email address will not be published. Required fields are marked *