Want to move or copy or move an Excel sheet from one workbook to another? Follow these steps to learn how.
It may not be often but there will be situations where you might want a specific sheet from a workbook copied to another workbook. For example, I have a subscription tracker sheet with all the currently active subscriptions in a separate workbook and I want that sheet in my budget workbook. So, rather than manually copying all the data, I copied the Excel sheet to the workbook I wanted. It’s a much simpler process and prone to fewer errors, especially with complicated formulas, charts, and scripts.
In this quick and straightforward tutorial, let me show you how to copy/move an Excel sheet to another workbook in simple steps. Let’s get started.
Copy or Move Excel Sheet From One Workbook to Another Workbook
- Open both Excel workbooks.
- Right-click on the sheet tab you want to copy.
- Select the “Move or copy” option.
- Choose the workbook to which you want to move/copy from the top dropdown.
- Select “(move to end)” in the “Before sheet” section.
- Optionally, select the “Create a copy” checkbox if you want to copy the sheet.
- Click “OK“.
- With that, the selected Excel sheet is moved/copied to the chosen workbook.
Detailed Steps (With Screenshots)
First, open both Excel workbooks: the source workbook (containing the sheet you want to copy/move) and the destination workbook (where you want to copy/move it).
In the source workbook, right-click on the sheet tab you want to copy/move and select the “Move or copy” option.
The above action opens the “Move or Copy” dialog. Here, select the destination workbook from the “To book” dropdown menu.
Next, under “Before sheet,” select “(move to end).” This places the copied/moved sheet at the end of all sheet tabs in the destination workbook. You can always rearrange the sheets later.
If you’d like to copy the sheet, leaving the original in the source workbook, make sure to select the “Create a copy” checkbox at the bottom of the dialog box.
Click the “OK” button.
That is it. With that, the selected sheet is copied or moved from the source workbook to the destination workbook.
