• 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. Here's how:

  1. Select the worksheet 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 15.2.

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

  4. In the Before sheet list box, choose the worksheet before which you want the selected worksheet to be moved.

  5. To copy the selected worksheet instead of moving it, 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