To move a worksheet in Excel for Mac without rebuilding it, open both workbooks, select the sheet in its current workbook, then choose Edit > Sheet > Move or Copy Sheet. Pick the destination workbook and its insertion point, then click OK. To keep the original as well, select Create a copy before confirming. Microsoft documents these controls for Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. Move or copy a sheet in Excel for Mac

Choose whether to move or copy

Use Move when the sheet should leave its current workbook and live in the destination. Use Create a copy when both workbooks should retain a version. The checkbox is the key distinction: without it, the operation moves the sheet; with it, Excel copies it. Both workbooks must be open, and this is a worksheet-level operation, not a command to copy selected cells. Microsoft’s Mac instructions

Before starting, save your work and identify the source and destination workbook by their names. If several workbooks are open, this small check helps prevent choosing the wrong destination. The move/copy dialog provides a To book selection and a Before sheet selection, so decide where the transferred sheet belongs in the destination’s tab order. You can choose (move to end) to place it after the existing sheets.

Move the sheet to another open workbook

  1. Open the workbook that will receive the sheet, then open the workbook containing the sheet. Confirm both are open in Excel.

  2. In the source workbook, click the tab for the sheet to transfer. Check the tab name before proceeding, especially if neighboring sheets have similar names.

  3. From the macOS menu bar, choose Edit > Sheet > Move or Copy Sheet. The menu item is documented under Excel’s Edit menu; if you do not see it, confirm that the source workbook is active and a sheet is selected.

  4. In To book, select the destination workbook. In Before sheet, select the sheet that should follow the incoming sheet, or choose (move to end).

  5. For a move, leave Create a copy unselected. Click OK. Excel removes the sheet from the source workbook and places it in the destination at the chosen point.

  6. Save the destination workbook. If you moved the sheet, save the source workbook too so the removal is preserved. Recheck both workbook tabs before closing them.

The dialog’s order is easy to misread: “Before sheet” names the existing destination tab that the incoming sheet should precede. For example, choosing “Summary” inserts the transferred sheet immediately before “Summary”; “(move to end)” appends it. This positioning guidance follows directly from the control labels and Microsoft’s documented description of the option. Move or copy a sheet in Excel for Mac

Copy the sheet and retain the source

Follow the same steps, but select Create a copy before clicking OK. Excel inserts a duplicate in the destination workbook and leaves the original in place. The copy receives its own sheet tab, so inspect the tab names afterward and rename the duplicate if the two workbooks would otherwise contain confusingly similar names.

Excel also documents a separate way to duplicate a sheet within the same workbook: hold Option while dragging its tab, releasing the mouse button before releasing Option. That instruction is for a copy along the row of sheet tabs; for transfer to a different workbook, use the Move or Copy Sheet dialog instead. Move or copy a sheet in Excel for Mac

Check formulas, charts, and destination behavior

A worksheet can contain formulas and charts tied to other sheets or data elsewhere in a workbook. Microsoft cautions that moving a sheet between workbooks can cause errors or unintended results in formulas and charts that refer to it. After the transfer, inspect those formulas and charts in the destination, and check the source too if it still contains references to the moved sheet. Do not assume the workbook relationship is unchanged just because the tab and its visible contents arrived. Move or copy a sheet in Excel for Mac

A useful verification pass is to check a few representative items: a formula that refers to another sheet, a chart that uses the transferred sheet’s data, and any visible formatting or layout that matters to the task. This is a practical review sequence, not a guarantee that it catches every dependency. If a formula shows an error or a chart no longer represents the intended data, trace its references and update them deliberately rather than assuming a move repairs the relationship.

Excel’s documentation confirms that styles used on a worksheet are copied into the destination workbook when you move or copy that sheet. However, its separate instructions for Merge Styles apply to Excel for Windows versions and are not a documented Mac-specific fix in that source. Do not rely on that Windows menu path as a Mac command. Copy cell styles from another workbook

If a reference should point to data that remains in the original workbook, review it after transfer. If the sheet is meant to become self-contained, verify that its formulas no longer depend on sheets left behind. Those are different outcomes, so choose based on how the destination workbook is intended to work.

When copying cells is not the same solution

Copying a range of cells into a new sheet can reproduce visible values and some formatting, but it does not perform the documented worksheet transfer. Microsoft’s formula guidance shows that copied formulas can update relative references based on their new location, while moving a formula keeps its references unchanged. Those formula behaviors are an additional reason to use the sheet-level command when the task is to transfer the worksheet itself, then check references after moving it. Copy and paste a formula to another cell or worksheet in Excel for Mac

For a cell-only task, copying and pasting can be appropriate, but expect to review the result: formulas may need different references, and cell-level operations are not a substitute for moving a whole sheet with its tab and worksheet structure.

Keep the two-workbook task easy to resume

If you have both workbooks open while arranging other work on your Mac, keep the task anchored to the two workbook windows and the worksheet tab you intend to transfer. Wallo organizes existing open Mac windows and to-dos locally by goal, with keyboard focusing; it can help keep this particular transfer task grouped while you work. It does not move worksheets in Excel, restore closed sessions, or provide automatic tiling, cloud sync, timers, or AI.

Finish by confirming the sheet is in the expected workbook, at the intended position, and either absent from or retained in the source according to your choice. Save the relevant workbook files, then test important references and charts in context. That completes the transfer while keeping the key decision—move or copy—clear.

Sources