• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
How to Merge Sheets in Excel

How to Merge Sheets in Excel

Posted on September 19, 2019 by Kat Armstrong Leave a Comment

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!

You Might Also Like

  • How to Send Bulk Emails Using Mail Merge in Microsoft WordHow to Send Bulk Emails Using Mail Merge in Microsoft Word
  • How to Highlight Text in Google SheetsHow to Highlight Text in Google Sheets
  • How to Spell Check in Google SheetsHow to Spell Check in Google Sheets
  • Google Sheets: Change Graph ColorsGoogle Sheets: Change Graph Colors
  • Hide and Unhide Rows and Columns in Google SheetsHide and Unhide Rows and Columns in Google Sheets
  • Google Sheets: Add Multiple Lines of Text in Single CellGoogle Sheets: Add Multiple Lines of Text in Single Cell
  • How to Spell Check in ExcelHow to Spell Check in Excel
  • Excel Calculations Are WrongExcel Calculations Are Wrong

Filed Under: Office Tagged With: Excel 2019

Reader Interactions

Did this help? Let us know! Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Google Docs: Add a Border
  • Best Free PC Optimization Software
  • How to Use the Unique Function in Google Sheets
  • How to Use Data Validation in Google Forms
  • How to Use LaTeX Math Equations in Google Docs
  • Android: Access Gmail Emails Through Telegram
  • How to Restore a WhatsApp Backup
  • How to Fix Windows Blue Screen Error

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2019 Technipages · All Rights Reserved · Privacy