• 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 Comparison
    Google Sheets vs Excel Comparison
  • Spotify: How to Merge Playlists
    Spotify: How to Merge Playlists
  • Can iPhone 11 Merge Phone Calls?
    Can iPhone 11 Merge Phone Calls?
  • OneDrive: We Couldn't Merge The Changes in Office File
    OneDrive: We Couldn't Merge The Changes in Office File
  • Word: Merge Comments and Changes from Multiple Documents
    Word: Merge Comments and Changes from Multiple Documents
  • How to Send Bulk Emails Using Mail Merge in Microsoft Word
    How to Send Bulk Emails Using Mail Merge in Microsoft Word
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank

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

  • Bitwarden: How to Manually Autofill a Login Form
  • Bitwarden: How to Copy the Username and Password of an Entry
  • Bitwarden: How to Open the URL Associated with an Entry
  • How to Increase the Size of Text on Any Website on iPad
  • Chrome: How to Fix Can’t Scroll Using Scrollbars
  • Samsung Galaxy S 21 Plus: How to Check How Much Memory Is Left
  • Google Photos: How to Export Your Albums
  • Bitwarden: How to Deauthorize All Sessions

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