Moving and Copying a Worksheet

graphics/microsoft18.gif

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

graphics/one_icon.jpg

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

graphics/tow_icon.jpg

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.

graphics/three_icon.jpg

Release the mouse button.

graphics/04inf06.jpg

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

graphics/one_icon.jpg

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.

graphics/tow_icon.jpg

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

graphics/three_icon.jpg

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.

graphics/foure_icon.jpg

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

graphics/five_icon.jpg

Select the Create A Copy check box.

graphics/six_icon.jpg

Click OK.

graphics/04inf07.jpg

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.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net