• 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

  • Google Sheets vs Excel ComparisonGoogle Sheets vs Excel Comparison
  • Can iPhone 11 Merge Phone Calls?Can iPhone 11 Merge Phone Calls?
  • Word: Merge Comments and Changes from Multiple DocumentsWord: Merge Comments and Changes from Multiple Documents
  • OneDrive: We Couldn't Merge The Changes in Office FileOneDrive: We Couldn't Merge The Changes in Office File
  • How to Send Bulk Emails Using Mail Merge in Microsoft WordHow to Send Bulk Emails Using Mail Merge in Microsoft Word
  • Google Sheets: How to Shade Every Other RowGoogle Sheets: How to Shade Every Other Row
  • How to Convert Google Sheets to PDFHow to Convert Google Sheets to PDF
  • Google Sheets Won't Let Me Type - Fix GuideGoogle Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not PrintingTroubleshooting Google Sheets Not Printing

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

  • Microsoft Teams: Mouse Scroll Wheel Not Working
  • Fix Microsoft Teams Browser Not Supported
  • Android 10: How to Adjust the Keyboard Size
  • OneNote Error Code 0xE00001AE – Fix
  • WhatsApp: How to Change Your Phone Number
  • Fix OneNote Error 0xe00001bb: Section Is Corrupted
  • Zoom: How to Show the Unread Message Icon
  • How To Calculate Tips on Android

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 2021 Technipages · All Rights Reserved · Privacy