Whether you're an Excel enthusiast or a novice trying to solve a problem, migrating sheets and information between separate workbooks is a useful skill. Fortunately, this process is relatively simple, once you know how.
In this article, we will show you how to copy a sheet from another workbook in Excel.
How to Copy a Sheet to Another Workbook in Excel on PC
There are two main ways to copy a sheet to another workbook on a PC:
First of all:
- Open both spreadsheets.
- Right-click on the sheet you want to move.
- Click on “Move or copy”.
- Click the "To book" drop-down menu and find the workbook you want to move this sheet to.
- Check the "Create a copy" box at the bottom of the window.
- Click on OK. "
This will move the sheet to another workbook.
Notes: Always check if all information has migrated with the sheet, including links and features.
- Open both spreadsheets.
- Click and drag the sheet you want to move to the other workbook.
- Click and hold “CTRL” before releasing the sheet.
- The copy will appear.
If the formulas didn't migrate correctly, try the following: copy the sheet with all the formulas you created to another workbook, select all the cells in the sheet (Ctrl+A), right-click "Copy" or CTRL+C and paste the information into the separate workbook. This should also copy the formulas.
How to copy a sheet to another workbook without links or references
Here's how to remove all links to the previous workbook when copying a complex sheet:
- Save the workbook with a new name, then open the new one.
- Click on the sheet you want to move, right click then "Move or copy".
- In the “To reserve” drop-down menu, select “(new book)” then “OK”.
- The new one will open automatically.
- Click on the "Data" tab at the top of the page.
- Search for "Connections", then "Edit Links", then "Break Link".
This should remove all links from previous workbooks, but leave your formulas intact.
Your formula does not work?
If your formula isn't working, here are some tips to help you fix the problem:
- Check your parentheses. Sometimes when you write a longer formula, you can forget to close one.
- Be sure to use double quotes "correctly". The double quotes tell the spreadsheet to treat everything between them as text. If you put a number in quotes, that may be the reason for the error.
- Do not use commas or currency signs when entering numbers. As the two symbols have distinct meanings in terms of functionality. Make sure you enter the numbers as "3000", but format the cells to output the numbers as required.
How to Copy a Sheet to Another Workbook in Excel on a Mac
The process on a Mac is slightly different. Here's how to copy a sheet for Mac users:
- Open the receiving workbook.
- You should find the workbook with the sheet you want to copy under the "Window" menu. Click on it, then click on the sheet you want to copy.
- Look for the “Edit” menu option, then “Sheet” then “Move or copy a sheet”.
- Select the workbook you want to move the sheet to from the "To book" menu (to create a new workbook with the copied worksheet, select "(new book)".
- Select the “Create a copy” box at the bottom and click “OK”.
Excel Problems for Mac Users
As Microsoft Office package was designed mainly for Windows users, some issues on Mac OS are unavoidable. If you can't open an Excel file, here are some quick fixes you can try:
- Close the app and open it again. Hopefully this simple solution will fix the problem.
- Restart your Mac.
- Try opening the document in safe mode.
- Check if your operating system is up to date.
- Check if your Office package is up to date (open Office then “Help”, “Check for updates.”)
- Disable/enable any add-ins that may cause problems (“Tools” then “Excel Add-ins.”)
One step closer to mastery
Often the solution to a problem is just a few mouse clicks away. With the tips and tricks provided in this article, now you should know how to copy a sheet to another workbook in Excel. This will allow you to migrate information with minimal hassle.
Have you ever tried to move a sheet to another workbook before? Did you use any of the tips from the article? Let us know in the comments section below.