How to Merge Excel Worksheets Into a Workbook

Written by jered slusher
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Merge Excel Worksheets Into a Workbook
(Jack Hollingsworth/Photodisc/Getty Images)

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:
Moderate

Other People Are Reading

Instructions

  1. 1

    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.

  2. 2

    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.

  3. 3

    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.

  4. 4

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.