Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Merge Multiple Excel Files Into Only One Sheet

Date:2021-6-25 Author:Sandra

It is common to combine multiple Excel Worksheets into one in our daily work. Many friends may choose to open each table in turn and then copy and paste them together. This only works with a small number of files, but too many files can be a huge waste of time. So today I’m going to share with you a quick and easy way to do it.

We need to put all the worksheets in one file first.

How To Merge Multiple Excel Files Into Only One Sheet

Then open a new Excel worksheet. Go to the Data tab and click the arrow of Get Data, choose From Folder in From File.

How To Merge Multiple Excel Files Into Only One Sheet

Chose the folder we just created.

How To Merge Multiple Excel Files Into Only One Sheet

Choose the Combine & Transform Date behind Combine in the new open-up box.

How To Merge Multiple Excel Files Into Only One Sheet

Then click on Sheet 1, hit OK.

How To Merge Multiple Excel Files Into Only One Sheet

You can preview what the merged sheet will look like in the Query Editor.

How To Merge Multiple Excel Files Into Only One Sheet

Go to Close & Load.

How To Merge Multiple Excel Files Into Only One Sheet

Now you have finished all the steps. And all the Excel files are put into one sheet.

How To Merge Multiple Excel Files Into Only One Sheet
How To Merge Multiple Excel Files Into Only One Sheet
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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