Combine Multiple Worksheets/Ranges into One Worksheet in Excel 365!!
Tags: combinemultipleworks, kutoolsexceltutorial, kutools
Published: 2020-12-03 09:57:57

---
title: Combine Multiple Worksheets/Ranges into One Worksheet in Excel 365!!
published: true
date: 2020-12-03 05:43:04 UTC
tags: CombineMultipleWorks,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/combine-multiple-worksheets-ranges-into-one-worksheet-in-excel-365/
---

In this tutorial, we will guide you to learn the steps to **Combine Multiple Worksheets/Ranges into One Worksheet in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Combine Worksheets from Workbooks into One Worksheet:

If you want to combine worksheets/ranges from different workbooks into one worksheet, follow the below instructions.

- Go to the **Kutools Plus Tab, select** the **Combine** option.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-18.png)<figcaption id="caption-attachment-17260">Kutools Plus Tab</figcaption>

- It will display a **prompt box,** you need to **click** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Prompt-box-2.png)<figcaption id="caption-attachment-17261">Prompt box</figcaption>

- Now, it will open the **Combine Worksheets – Step 1 of 3** dialog box.
- **Combine Operations –** In this section, you need to **select** the **Combine multiple worksheets from workbooks into one worksheet**  option.
- Then, **click** the **Next** button.

![Combine Worksheets - Step 1 of 3 dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-6.png)<figcaption id="caption-attachment-18521">Combine Worksheets – Step 1 of 3 dialog box</figcaption>

- It will open the **Step 2 wizard** , where you need to **select** the **workbooks** and **worksheets** that you want to combine.

![Click Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-6.png)<figcaption id="caption-attachment-18522">Click Next button</figcaption>

### Configure the settings as below:

### #1) **Add workbooks to merge**

- In the **Add drop-down** list, you can **click** the **Files(s)** button to add one workbook or multiple workbooks to merge.
- **Folder –** It will add all workbooks of the folder into the workbook list to merge.
- **OneDrive File(s) or OneDrive Folder –** This will add one or multiple OneDrive files from one folder or different folders as you need.

![Add option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Add-option.png)<figcaption id="caption-attachment-17264">Add option</figcaption>

### #2) Sort all workbooks or worksheets in the workbook

- **Sort drop-down list –** It is used to sort all workbooks or worksheets in the list box.

### #3) Save/Access one scenario of your operation

- You can save the settings of **Step 2** for future use. You need to **click** the **Save** option under the **Scenario** drop-down list.
- Then, you need to give the **name** for the scenario in the popping-out dialog box.

![Scenario option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-17.png)<figcaption id="caption-attachment-17269">Scenario option</figcaption>

### #4) Open workbooks which have been encrypted with the password

- **Password –** This option is used to combine the workbooks which have been encrypted with passwords.
- **Password Manager Dialog box – Click** the **Add** button, **enter** the workbook **password** into the text box. Then, **fill** the **Label** and **click** the **OK** button.
- **Repeat the above step** until the workbooks passwords are added to the manager, then **click** the **OK** button to close the window.

### #5) Same range option

- Using this option, you can select the specified range in one worksheet and select the same range from all other sheets in the workbook automatically.

![Same range option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-14.png)<figcaption id="caption-attachment-17270">Same range option</figcaption>

### #6) Same Sheet option

- With this option, you can select the specific sheet across multiple workbooks that contain a specific sheet name.

![Same Sheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-11.png)<figcaption id="caption-attachment-17271">Same Sheet option</figcaption>

- After configuring **Step 2** , kindly **click** the **Next** button.

![Click Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-5.png)<figcaption id="caption-attachment-18528">Click Next button</figcaption>

- It will go to the **Step 3** wizard. In this dialog box, you need to specify the operations that you need.
- Then, **click** the **Finish** button.

![Step 3 wizard](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-5.png)<figcaption id="caption-attachment-18529">Step 3 wizard</figcaption>

- Now, it will open the **Specify the file name and location for the combined workbook dialog box** , where you need to **select a folder to save** the combined workbook.

![Click Save Button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7-4.png)<figcaption id="caption-attachment-18530">Click Save Button</figcaption>

- **Click** the **Save** button.
- The new workbook with the information of original workbooks is created as shown in the below image.

![Combined sheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8-4.png)<figcaption id="caption-attachment-18531">Combined sheets</figcaption>

- **Output file link –** You can click this link to view the combined workbook directly.
- Then, all worksheets of the worksheets are combined into one worksheet according to your settings.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Result-1.png)<figcaption id="caption-attachment-18532">Result</figcaption>

## Steps to Combine Worksheets of Same Names into One Worksheet:

To combine worksheets/ranges of the same names into one worksheet, follow the below instructions.

- Go to the **Kutools Plus Tab, select** the **Combine** option.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-18.png)<figcaption id="caption-attachment-17260">Kutools Plus Tab</figcaption>

- It will display a **prompt box,** you need to **click** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Prompt-box-2.png)<figcaption id="caption-attachment-17261">Prompt box</figcaption>

- Now, it will open the **Combine Worksheets – Step 1 of 3** dialog box.
- **Combine Operations –** In this section, you need to **select** the **Combine multiple worksheets from workbooks into one worksheet**  option.
- Then, **click** the **Next** button.

![Combine Worksheets - Step 1 of 3 dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-6.png)<figcaption id="caption-attachment-18521">Combine Worksheets – Step 1 of 3 dialog box</figcaption>

- In **Step 2** , please add the workbooks that you want to combine worksheets of same into one worksheet.

![Click Next button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/9-3.png)<figcaption id="caption-attachment-18534">Click Next button</figcaption>

- In **Step 3** , refer to the above section to configure the settings. Then, **hit** the **Finish** button to get the result.

![Step 3 wizard](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-5.png)<figcaption id="caption-attachment-18529">Step 3 wizard</figcaption>

- You can see that all worksheets of the same name have been combined into one worksheet as shown in the following screenshot.

![Combined sheets](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10-3.png)<figcaption id="caption-attachment-18535">Combined sheets</figcaption>

- **Output file link –** You can click this link to view the combined workbook directly.
- Then, all worksheets of the worksheets are combined into one worksheet according to your settings.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11-3.png)<figcaption id="caption-attachment-18536">Output</figcaption>

## Combine Same/Different Ranges from Different Worksheets:

To combine the same or different ranges from different worksheets, follow the below steps.

- Go to the **Kutools Plus Tab, select** the **Combine** option.

![Kutools Plus Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-18.png)<figcaption id="caption-attachment-17260">Kutools Plus Tab</figcaption>

- It will display a **prompt box,** you need to **click** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Prompt-box-2.png)<figcaption id="caption-attachment-17261">Prompt box</figcaption>

- Then, it will open the **Combine Worksheets – Step 1 of 3** dialog box.
- **Combine Operations –** In this section, you need to **select** the **Combine multiple worksheets from workbooks into one worksheet**  option.
- Then, **click** the **Next** button.

![Combine Worksheets - Step 1 of 3 dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-6.png)<figcaption id="caption-attachment-18521">Combine Worksheets – Step 1 of 3 dialog box</figcaption>

- In **Step 2** , please add the workbooks that you want to combine worksheets of same into one worksheet.
- In **Step 3** , refer to the above section to configure the settings. Then, **hit** the **Finish** button.
- You can see the ranges from different or same worksheets will combine into one worksheet as shown in the following screenshot.
- After clicking the **Finish**  button, ranges of different worksheets have been combined into one worksheet as shown in the following screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/12-1.png)<figcaption id="caption-attachment-18539">Output</figcaption>

## A Brief Summary:

In the above article, you Clearly understand the steps to **Combine Multiple Worksheets/Ranges into One Worksheet in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!](https://geekexcel.com/calculate-cell-values-based-on-font-background-or-conditional-color-in-excel-365/)
- [How to Print Multiple Workbooks/Worksheets from Directories in Excel 365?](https://geekexcel.com/how-to-print-multiple-workbooks-worksheets-from-directories-in-excel-365/)