Excel can copy an entire worksheet into another workbook while preserving its cells, formulas, and most worksheet formatting. Both workbooks should be open before you use the Move or Copy command.
How to Copy an Excel Sheet to Another Workbook
Step 1: Open both workbooks
Open the workbook containing the sheet and the workbook that should receive the copy.
Step 2: Right-click the worksheet tab
At the bottom of the source workbook, right-click the tab for the worksheet you want to copy.
Step 3: Choose Move or Copy
Select Move or Copy from the menu.
Step 4: Select the destination workbook
Open the To book menu and choose the other open workbook.
Step 5: Choose the sheet position
Select where the copied worksheet should appear in the destination workbook.
Step 6: Select Create a copy
Check Create a copy. If you leave this unchecked, Excel moves the worksheet instead of leaving the original in place.
Step 7: Select OK
Excel creates the worksheet in the destination workbook. Save the destination file when you are finished.
Check Formulas After Copying
Formulas that refer to other sheets, workbooks, named ranges, data connections, or external files can behave differently after a worksheet is copied. Review important formulas and links before relying on the copied sheet.
If the Destination Workbook Is Not Listed
Make sure it is open in the same Excel environment. Some workbook formats and protected/shared configurations can also limit worksheet operations. Saving a compatible copy of the destination workbook may be necessary.
Additional Information
If you only need the displayed values rather than a functioning worksheet, copying the cells and using a suitable Paste option can avoid bringing formulas or external links into the destination file.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.