Move or copy a sheet

When you need to reorganize your data, you can easily change the order of sheets in a workbook, or move or copy a sheet to another workbook. But be aware that calculations or charts that are based on sheet data may become inaccurate if you move the sheet.

Tab scrolling buttons

Sheet tab

 Add a sheet

 Tab split bar

Do any of the following:

Copy a sheet

1. Hold down OPTION .

2. Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs.

   Important: Release the mouse button before you release the OPTION key.

Copy a sheet to another workbook

1. Open the workbook that you want to copy the sheet to.

2. On the Window menu, click the workbook that contains the sheet that you want to copy.

   Click the sheet that you want to copy.

3. On the Edit menu, click Move or Copy Sheet.

4. On the To book pop-up menu, click the workbook that you want to copy the sheet to.

   Tip: To create a new workbook that contains the moved sheet, click new book.

5. In the Before sheet box, click the sheet that you want to insert the copied sheet before, or click move to end.

6. Select the Create a copy check box.

7. Click OK.

Move a sheet

• Drag the sheet tab to the location that you want along the row of sheet tabs.

Move a sheet to another workbook

Caution: When you move a sheet to another workbook, check any formulas or charts that refer to data on the sheet because moving the sheet might cause errors or produce unintended results in your data. Similarly, if you move a sheet that is referred to by a 3-D references, the calculation might include or leave out data on the sheet.

1. Open the workbook that you want to move the sheet to.

2. On the Window menu, click the workbook that contains the sheet that you want to move.

   Click the sheet that you want to copy to the other workbook.

3. On the Edit menu, click Move or Copy Sheet.

4. On the To book  pop-up menu, click the workbook that you want to move the sheet to.

   Tip: To create a new workbook that contains the moved sheet, click new book.

5. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end.

6. Click OK.

Change the color of a sheet tab

Coloring the sheet tabs can help you keep track of your information in a large workbook.

1. Hold down CONTROL and click the sheet tab.

2. Click Tab Color, and then click the color that you want to use.

See also

Rename a sheet