Working with Multiple Worksheets

When working in Excel XP 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 EditMove 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 positioned in the workbook.

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