• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 9. Working with Worksheets > Moving and Copying Worksheets

Moving and Copying Worksheets

You can move or copy worksheets within a workbook or from one workbook to another. Here's how:

  1. Select the worksheet(s) you want to move or copy. If you want to move or copy worksheets from one workbook to another, be sure to open the target workbook.

  2. Open the Edit menu and choose Move or Copy Sheet. The Move or Copy dialog box appears, as shown in Figure 9.2.

    Figure 9.2. The Move or Copy dialog box asks where you want to copy or move a worksheet.

  3. To move the worksheet(s) to a different workbook, select that workbook's name from the To Book drop-down list. If you want to move or copy the worksheet(s) to a new workbook, select (new book) in the To Book drop-down list. Excel creates a new workbook and then copies or moves the worksheet(s) to it.

  4. In the Before Sheet list box, choose the worksheet before which you want the selected worksheet(s) to be moved.

  5. To copy the selected worksheet(s) instead of moving them, select Create a Copy to put a check mark in the check box.

  6. Select OK. The selected worksheet(s) are copied or moved as specified.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint