Copying and Moving Worksheets

Contact Us or call 1-877-932-8228
Copying and Moving Worksheets

Copying and Moving Worksheets

Changing the order of worksheets in Excel involves moving or copying worksheets; you can move or copy worksheets within a workbook.

To move a worksheet:

  1. Select the worksheet you want to move.
  2. From the HOME tab, in the Cells group, select Format.
  3. From the Format drop-down, select Move or Copy Sheet under Organize Sheets.
  4. In the Move or Copy dialog box, under Before sheet:, select the location to which to move the worksheet, and then click OK.

To copy a worksheet:

  1. Select the worksheet you want to copy.
  2. From the HOME tab, in the Cells group, select Format.
  3. From the Format drop-down, select Move or Copy Sheet under Organize Sheets.
  4. In the Move or Copy dialog box, select Create a copy.

The copy now appears with the same title and (2).

Next