Microsoft Excel allows you to create multiple worksheets inside a workbook to group multiple data sets that are alike. However, sometimes you might want to move or copy worksheets from one workbook to another to get a more complete collection of worksheets. Instead of re-entering all of your information into a new worksheet of the workbook, you can use Microsoft Excel to move or copy the worksheet from one workbook to another.
- Skill level:
Other People Are Reading
Open Microsoft Excel. Press and hold the "Ctrl" key on your computer's keyboard and press the "O" key to start the "Open" window. Click on the first workbook you would like to open. Press and hold the "Ctrl" key and click on the second workbook. Press the "Open" button at the bottom right of the "Open" window to open both workbooks.
Click the workbook on the bottom Windows toolbar that contains the sheet that you would like to merge. Right-click the sheet tab that you would like to move or copy. For example, right-click "Sheet 1" tab at the bottom left of the Excel workspace to select the first sheet to merge. Click "Move or Copy..." from the drop-down list.
Click the "To Book" drop-down menu on the "Move or Copy" window. Click on the workbook to which you want to move the worksheet. For example, if your other workbook is called "Book 1," click on the "Book1" workbook. Click the sheet name of where you want the sheet to appear in the new workbook from the "Before sheet" menu. If you want your sheet to appear at the end of the workbook, click "move to end" from the "Before sheet" menu.
Check the "Create a copy box" if you want to maintain the sheet in the current workbook. Otherwise, leave the box unchecked to move the sheet from one workbook to the other. Press the "OK" button to move or copy the worksheet from one workbook to the other.
Tips and warnings
- Repeat the process to merge multiple worksheets back and forth between workbooks.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for