Move Or Copy A Sheet In Excel For Mac - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Applies ToExcel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 for Mac

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.

1. Tab scrolling buttons

2. Sheet tab

3.  Add a sheet

4.  Tab split bar

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, point to Sheet, and then select Move or Copy Sheet.

4. On the To book box, select the workbook that you want to copy the sheet to.

   Tip: To create a new workbook that contains the copied sheet, select (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. The small black arrow shows where the sheet will go when you let it go.

  

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.

1. Make sure both workbooks are open.

2. Go to the workbook that you want to move the sheet to.

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

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

4. On the Edit menu, point to Sheet, and then click Move or Copy Sheet.

5. In the To book  box, select the workbook that you want to move the sheet to.

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

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

7. 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. Point to Tab Color, and then click the color that you want to use.

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×