How to combine multiple Excel files into one – Fast guide

You are working with multiple Excel files but you need all of them to be merged into one, in this article you will learn how merge excel files into one online; You will be surprised how easy and fast this process is.

In this article we show you how to unify different files. But it is also important that you learn how to join or combine multiple cells in Excel.

A few simple steps will help you unify multiple Excel documents in a single file; to make it easier to locate them and thus be better organized.

Excel allows you merge multiple files into one online in two different ways; one is manual but it is very simple and the other is through a more advanced process called VB, but here we will show you how to do it and you decide which method to use.

Can you join multiple Excel files?

These types of options are possible for handling Excel, managing to unify several files in a single document, which will allow a better and easier access and organization in the document. There are different methods to achieve it, Here we explain one of them.

Steps to join multiple Excel files

• Should open the excel documents you want to group. For them, you can open the document in safe mode.
• If the files you want to group have more than one worksheet; you must go to the end of the sheet and click on the first element.
• Then you must press the “Temporary capitalization” or also known as tecla Shift; you must hold down this key until you reach the last sheet you want to select.
• When I reach the end of the selection, you need to right click to select all sheets.
• Then hover your mouse cursor over the sheets you have selected and press the right mouse button; to display a menu where you must choose the option “Move or copy”.
• A window will open where you can create a new document, which will group all the worksheets you selected in step 4. In this window there is a box that says “Create one Copy“; you can choose that option so that the selected articles remain in the original documents and a copy goes to the new document.
• Immediately a new document will be created with the files you want to unify, what you must give safe and name the new document.
• Now you need to join the other files to this new document you just created.
• For that you must go to the document you want to group and you must open it and repeat the steps 2, 3, 4 Y 5.
• When the window opens, choose the document you created earlier; (It is important that you do not close the document you just created until you have grouped all the files that you want to unify; because if you close it that new document will not appear in that window).
• later a tab will open where the files you previously grouped will appear; now you must choose if you want these new files to appear before or after the ones that are already grouped. Remember to give the option create a copy so it doesn't move the original document.
• Accept to save the changes.

If you see the new document created you will see all the files you joined at the bottom. If over time you want to add other documents you must follow the steps above.

Advantages of joining Excel sheets

The biggest benefits of this is the order and handling of documents in a single file, this makes it easier to locate, Edit and add multiple information faster and easier Without having so many separate documents, but, all grouped in one, avoiding mixing and confusing them, so we can identify everything in a faster and less dispersed way.

Using Visual Basic:

With Visual Basic Custom Functions, joining excel files will only take a few seconds. In this method we will use a macro, who will do all the work.

1. Should create a new folder; in it you must place all the files you want to group.
2. Open a new Excel document, in which the files you want to join will be grouped.
3. Then you must go to Editor de Visual Basic, dialing command keys Alt + F11.
4. Once open on the menu “Insert”, you press the option “Module”.
5. A blank window will open where you will paste a code (update that code with the folder path where you put the files you want to group).
6. Place your cursor anywhere in the code and you press F5.
7. All the files you selected will be automatically moved to the new excel document.

That's how easy it is to combine multiple Excel files on one only; use the one you like the most and organize your work more efficiently. If what you need is to consolidate data in Excel from several sheets into one, we invite you to continue reading.