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

Chapter 4. Edit > Edit Move or Copy Sheet

Edit Move or Copy Sheet

Moves or copies the selected sheets within the selected workbook to another open workbook or to a new workbook. You specify how you want to copy or move the worksheets on the Move or Copy dialog, as shown in Figure 4-11.

You can only copy or move worksheets between currently open workbooks, or to a new workbook. Make sure you open the workbook where you want to move or copy the worksheet prior to selecting this option.

Select the "Create a copy" checkbox if you want to place a copy of the worksheet in another workbook without changing the location of the original.

Figure 4-11. Move or Copy dialog


Select the workbook location to move or copy the worksheet to. By default, the currently selected workbook is listed in the "To book" field. To select another open workbook, select the down arrow button and highlight the name of the workbook to move or copy the worksheet to. If you select (new book), a new workbook is opened and the selected worksheet is copied or moved into the new workbook. If you select the (new book) option in the To book field, the "Before sheet" list will be empty because the worksheet is placed in the new workbook as the only worksheet. You can also drag a worksheet to a new location by clicking on the sheet tab and dragging it to another location in the workbook or to another open workbook. This method can be more tedious if your workbook has several worksheets.

If you move the worksheet to another workbook that contains a worksheet with the same name, Excel modifies the name of the copied worksheet, since you cannot have two worksheets with the same name within the same workbook. For example, if the copied worksheet is named Sheet 1 it becomes Sheet1 (2).

When you copy or move a worksheet, all custom formatting and defined names are copied into the new workbook.

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