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. Format in Cells Group of Home Tab
  3. From the Format drop-down, select Move or Copy Sheet under Organize Sheets. Move or Copy Sheet
  4. In the Move or Copy dialog box, under Before sheet:, select the location to which to move the worksheet, and then click OK. Move or Copy Dialog Box

To copy a worksheet:

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

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

Copy

Next