How to Merge Sheets in Excel

When you are working in Excel, you may end up with a lot of data spread across multiple sheets within the same workbook. What happens if you need to combine that information? Sure, you could copy and paste everything. However, that is not only time consuming – it could also seriously screw up your careful formatting or your formulas.

There is definitely a much easier way to handle this, and it only takes moments. There are a couple of different things you can do in this situation.

How to Merge Sheets in Excel Into a New Workbook

1. Open all of the sheets you with to merge together.
2. At the top of the page, click “Home” and then “Format.”
3. Now, choose “Move or Copy Sheet.”
4. There will now be a small drop-down menu that pops up. Select the “New Book” option and click “Ok.”

How to Merge Excel Sheets Into a Single Workbook

1. Open the Workbook into which you would like to merge all of your Sheets. This is called the “destination workbook.”
2. Next, open up any workbooks containing Sheets you need to move.
3. Right-click on the first Sheet tab to be moved, and then select ”Move or Copy.”
4. A drop-down menu will appear. Select ”To” here.
5. Choose an empty worksheet in the book you are moving this existing sheet to. Keep in mind you can rearrange it later.
6. Now, click on ”OK.”
7. Repeat all of these steps for each sheet you need to move into the existing destination workbook.

Do you have any other questions about Google Sheets that I can answer for you? I have a couple of upcoming articles that will answer some things, but am always willing to do more in order to help you.

Happy moving and merging!