Tuesday , October 15 2019
Home / Tutorials / Excel Tutorial / How to Duplicate/Clone/Move entire worksheet (s) in MS Excel – Must Watch

How to Duplicate/Clone/Move entire worksheet (s) in MS Excel – Must Watch

I’ll describe five ways to duplicate a worksheet. which involve menus, and mouse-and-keyboard trick.

First Way

You may already be familiar with the first approach shown in this video:

  • Click Format on Excel’s Home menu.
  • Choose Move or Copy Sheet.
  • At this point the Move or Copy dialog box appears:
    1. Copying within the same workbook: Click Create a Copy and then click OK.
    2. Copying to another workbook: Select the workbook name from the To Book list, click Create a Copy, and then click OK.
    3. Moving a sheet to another workbook: Select the workbook name from the To Book list, and then click OK.

Second Way

A second way to duplicate worksheets involves right-clicking on any worksheet tab, and then choosing Move or Copy from the context menu that appears. From there follow the same steps within the Move or Copy dialog box as described above.

Third Way

As shown in My Video, personally I find it easier to use a third approach, which involves holding down the Ctrl key while I use my left-mouse button to drag a worksheet to the right. This action will duplicate a worksheet without involving any menus.

Fourth Way

You can copy or move worksheet (s) from one workbook to another existing (file should be open) workbook:

  • Click Format on Excel’s Home menu. or right click on selected sheets
  • Choose Move or Copy Sheet.
  • At this point the Move or Copy dialog box appears:
    1. Copying to another workbook: Select the workbook name from the To Book list, click Create a Copy, and then click OK.
    2. Moving a sheet to another workbook: Select the workbook name from the To Book list, and then click OK.

Fifth Way

You can copy or move worksheet (s) from one workbook to New workbook:

  • Click Format on Excel’s Home menu. or right click on selected sheets
  • Choose Move or Copy Sheet.
  • At this point the Move or Copy dialog box appears:
    1. Copying to New workbook: Select the new workbook from the To Book list, click Create a Copy, and then click OK.
    2. Moving a sheet to New workbook: Select the new workbook from the To Book list, and then click OK.

About sheshpal

Check Also

Name Box in Excel

MS Excel Cell Addressing Name Box and Navigation Tricks

1. Determine the address of the currently selected cell. As shown in Figure 1, the …

Leave a Reply

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