Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Do you have two or more Excel files you rather merge into one? This guide covers 8 steps to merge Excel files.
In this Itechguide, I will merge the files shown in this image into a single file. You can merge all the files into a new excel file or merge all of them into one of the existing file.
I may use Excel file and Excel workbook interchangeably. They both refer to the same thing.
Follow the steps below to combine multiple Excel files into 1 file:
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
- If you want to merge all the existing files into a new Excel workbook, create the new Excel workbook and open it. However, if you want to merge all into one of the existing workbooks, open the workbook you want to merge all others into.
In this example, I will merge all other workbooks into the first worksheet in the list.
- Then, open all other Excel files. The quickest way to open all the workbooks is to select all of them and press the enter key on your keyboard. You may also right-click on the selected files and click Open.
You have to open all the Excel files to be able to combine them into one.
- Once all the files are open, maximize the first one you want to merge.
- Then, right-click the worksheet you want to merge and select Move or Copy.
- On the Move or Copy pop-up, click the To book drop-down. All the Excel files open on your PC will be displayed in the drop-down.
- Select the excel file you want to the merge other files into.
- Finally, to merge Excel files, check the Create a copy checkbox, select (move to end) and click OK.
Selecting (move to end), moves the excel worksheet you are merging to the end of the worksheet you are merging it into.
Once you click OK, a copy of the worksheet will created in the destination Excel file. If you open the Excel file you merged the worksheet into, the worksheet you merged into it will be available on the workbook.
- Repeat steps 3-7 for all the files you want to merge. For each step, to move the new worksheet after the last worksheet, select (move to end).
When you finishing merging the files, they will all appear as worksheets in the workbook you merged all of them into.
#1 Best Overall
Seagate 2TB Portable Hard Drive | USB 3.0 (STGX2000400) | Everyday HDD storage. Plug-and-play backup. Windows & macOS. Adobe CC trial included. 1-Year Warranty
- Easily store and access 2TB to content on the go with the Seagate Portable Drive, a USB external hard drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Conclusion
I hope you were able to merge Excel files with the steps in this Itechguide. I also hope that you found the guide helpful!
If you found it helpful, click on “Yes” beside the “Was this page helpful” question below. You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Rank #2
Seagate Portable 5TB External Hard Drive HDD – USB 3.0 for PC, Mac, PS4, & Xbox - 1-Year Rescue Service (STGX5000400), Black
- Easily store and access 5TB of content on the go with the Seagate portable drive, a USB external hard Drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Finally, for more Windows 10 Itechguides, visit our Microsoft Office How-to page. You may also find our Work from Home page very helpful.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Quick Recap
Bestseller No. 2
Bestseller No. 3
Best Value
Sale
UnionSine 500GB Ultra Slim Portable External Hard Drive HDD-USB 3.0 | for PC, Mac, Laptop, PS4, Xbox one, Xbox 360-(Black)
- [Upgraded Version] - This external hard drive features a mirrored logo stripe combined with a striped anti-slip design, and the rounded corners of the casing make it easier to grip. The stripes also have a heat dissipation function, ensuring stable and fast data transfer.
- 【Ultra-thin and quiet】 - The motherboard adopts JMicron 578 noise-free solution, giving you a quiet working environment. Lightweight and portable size designed to fit in your pocket for easy portability.
- 【Ultra-Fast Data Transfers】 - Pairing this external hard drive with JMicron 578 solution USB 3.0 and USB 2.0 interfaces enables blazing-fast data transfer. It boasts theoretical read speeds of up to 125MB/s and write speeds of up to 103MB/s.
- 【Plug and Play】 - With no software to install, just plug it in and the drive is ready to use.The hard disk chip is wrapped with an aluminum anti-interference layer to increase heat dissipation and protect data.
- 【What You Get】 - 1 x Portable Hard Drive, 1 x USB 3.0 Cable, 1 x User Manual, Gift-type shell packaging ,Three-year manufacturer's warranty and free technical support services.
Rank #4
Seagate Portable 4TB External Hard Drive HDD – USB 3.0, 1-Year Rescue | Everyday HDD storage. Plug-and-play backup. Windows & macOS. Adobe CC trial included. 1-Year Warranty
- Easily store and access 4TB of content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Rank #3
Seagate Portable 1TB External Hard Drive HDD – USB 3.0 for PC, Mac, PlayStation, & Xbox, 1-Year Rescue Service (STGX1000400) , Black
- Easily store and access 1TB to content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop. Reformatting may be required for Mac
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
