Moving and Copying a Worksheet

After adding several sheets to a workbook, you might want to reorganize them. You can arrange sheets in chronological order or in order of their importance. You can easily move or copy a sheet within a workbook or to a different open workbook. Copying a worksheet is easier and often more convenient then re-entering similar information on a new sheet. If you are moving or copying a worksheet a short distance, you should use the mouse. For longer distances, you should use the Move Or Copy Sheet command on the Edit menu.

Move a Worksheet Within a Workbook

Click the sheet tab of the worksheet you want to move, and then hold down the mouse button.

When the mouse pointer changes to a sheet of paper, drag it to the right of the sheet tab where you want to move the worksheet.

Release the mouse button.

Did You Know?

You can use the Create A Copy check box to move a worksheet . Clear the Create A Copy check box in the Move Or Copy dialog box to move a worksheet rather than copy it.

You can give your worksheet a different background . Click the tab of the sheet on which you want to insert a background, click the Format menu, point to Sheet, and then click Background. Select the picture you want to use as a background, and then click Insert.

Copy a Worksheet

Click the sheet tab of the worksheet you want to copy.

TIMESAVER Press and hold the Ctrl key while you drag a sheet name to copy a worksheet.

Click the Edit menu, and then click Move Or Copy Sheet.

If you want to copy the sheet to another open workbook, click the To Book list arrow, and then select the name of that workbook. The sheets of the selected workbook appear in the Before Sheet list.

TROUBLE? If the workbook you want to copy to does not show up in the To Book drop-down list, you must first open the other workbook.

Click a sheet name in the Before Sheet list. Excel inserts the copy to the left of this sheet.

Select the Create A Copy check box.

Click OK.

Did You Know?

You can copy or move a sheet to a different workbook . You must first open the other workbook, and then switch back to the workbook of the sheet you want to copy or move.

You can use groups to affect multiple worksheets . Click a sheet tab, press and hold Shift, and click another sheet tab to group worksheets. Right-click a grouped sheet tab, and then click Ungroup Sheet on the shortcut menu.