Excel Move Worksheet Animation tutorial

Excel2003 Introductory Animation Tutorial 44, Excel move or copy a worksheet.

Demo Animation

Operation Steps

If you want to copy and move the Excel worksheet, dragging with the mouse is not convenient, we can use menu commands to implement.

Open both the source workbook document and the destination workbook document. In the source workbook document, select the worksheet tab that you want to copy, right-click, and then in the shortcut menu that pops up, select the Move or copy sheet option, open the Move or Copy Sheet dialog box, and press the Drop-down button on the right side of the workbook. In the Drop-down list that pops up, select the destination workbook document (such as an in-place payroll. xls), and then select the location of the worksheet and press the OK button to move the worksheet.

Note: ① If you select the "Make Replica" option in the Move or Copy a worksheet dialog box, you can make the copy of the worksheet available. ② If you select more than one worksheet at a time, you can also move or copy multiple worksheets.