Working with Multiple Worksheets

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

Moving worksheets

When you move a sheet, you are moving it to a new location in this or another workbook.

To move a workbook:

  • Select the worksheet you want to move or copy.
  • Choose Edit Move or Copy from the menu bar.

    Edit and Move or Copy Sheet Menu Selections
  • In the Move or Copy dialog box, use the drop-down boxes to select the name of the workbook you will move the sheet to (the current workbook is the default). Also define where you want the sheet to be positioned in the workbook.

    Move or Copy Dialog Box
  • Check Create a copy to copy it.
  • Click the OK button to move the worksheet to its new location.