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

Lesson 15. Managing Your Worksheets > Moving and Copying Worksheets

Moving and Copying Worksheets

You can move or copy worksheets within a workbook, or from one workbook to another. Copying a worksheet enables you to copy the formatting of the sheet and other items, such as the column labels and the row labels. Follow these steps:

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

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

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

  3. To move the worksheets to a different workbook, be sure that workbook is open, and then select that workbook's name from the To Book drop-down list. If you want to move or copy the worksheets 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 worksheets to it.

  4. In the Before Sheet list box, choose which worksheet you want to follow the selected worksheets.

  5. To move the selected worksheet, skip to step 6. To copy the selected worksheets instead of moving them, select the Create a Copy option.

  6. Select OK. The selected worksheets 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