Working with Multiple Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Copying and moving worksheets

When you copy a sheet, you are doing just that—making a copy. When you move a sheet, you are moving it to a new location.

To move a worksheet within the same workbook, drag the sheet tab to the new location (a small black triangle appears) and drop it. To copy it, hold down the Control key while dragging the worksheet to its new location.

move sheet image

To move or copy between workbooks:

  • Select the worksheet you want to move or copy.
  • Choose EditMove or Copy.
  • In the Move or Copy dialog box, use the drop-down boxes to select the name of the workbook you are copying the sheet to and where you want the sheet positioned in the workbook.
  • Check Create a copy to copy it.
  • Click OK.

move or copy dialog box image