Merging multiple sheets in excel

Are you thinking to merge multiple excel worksheets or stuck in merging process. This article helps you to merge multiple worksheets and make one single report.

follow below steps to merge multiple excel sheets and make it a single worksheet.

Open new sheet

Once new file window opened, you need to select New Query option from Data menu tab.

Select the source files or folder from listed option and click on combine and load option from below window.

Excel will execute the query process and start merging all files into one excel sheet. outcome will be reflected in few seconds or minutes that vary on your data size & number of excel sheets which selected for merge process.

You can choose other option as well like scripting or other freeware software however this is simple & easy method. Hope this will help you and easy your day !!