Combine workbooks

1. Open two workbooks. In one workbook, hold down the ⌘ key and select the tabs you want to merge into the other.

2. Control-click the tabs and select Move or Copy to open the Move or Copy dialog.

3. Under To book, choose the destination workbook's name, and select where to put the sheets (before or after a sheet, or at the end).

4. Select Create a Copy if you want to keep the original workbook intact.

To combine data into one sheet, see Copy data from one sheet to another.
To link cells to other sheets, see Reference another sheet.

Combining workbooks isn't currently possible in Excel for the web. You can, however, combine workbooks in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.