Merge Cells in Excel Office 365 – Simple and Quick Ways!!
Tags: excelpreface, mergecellsinexcel, exceltutorials
Published: 2020-12-09 12:00:18

---
title: Merge Cells in Excel Office 365 – Simple and Quick Ways!!
published: true
date: 2020-12-09 11:57:47 UTC
tags: ExcelPreface,MergecellsinExcel,ExcelTutorials
canonical_url: https://geekexcel.com/merge-cells-in-excel/
---

In this article, we will explore how to **merge cells as you need** in **Excel Office 365** with the help of [ablebits.com](https://www.ablebits.com/). Here, we come up with simple steps to take this task. Let’s see them below!! 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)


## Things that can do with Merge Cells Option:

**Merge Multiple Cells into One:** You can easily merge multiple cells and place the result on the top left/right cell or the bottom left/right cell.

**Keep the Values when merging cells:** It will not delete the data when merging cells.

**Merge Columns row by row:** It will combine the columns and print the result on the left or right column.

**Manage the Result:** With the help of this option, you can easily remove the contents of the selected cells, wrap text.

**Merge Rows Column by Column:** Combine many rows and place the result in the top or bottom row.

**Separate Merged Values:** You can use a separator to separate the merged values in Excel. You can use a comma, semicolon, space, line break, or any character as you need. 

## Merge Columns into One:

To merge multiple columns into one, do as follows.

- First, you need to **select the input range** as shown in the below image.

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

- Go to the **Ablebits Data Tab, click** the **Merge Cells** option, then **select** the **Merge Columns into One** option from the menu.

![Select the Merge columns into one option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Merge-columns-into-one-option.png)<figcaption id="caption-attachment-19228">Select the Merge columns into one option</figcaption>

- Then, it will display the **Merge Cells Dialog Box**.
- **How to merge – Select** the **columns into one** option.
- **Separate values with –** You need to **select**  **any separator** from the drop-down list.
- **Place the results to – Select** the **left column** option from the drop-down list.
- Finally, **click** the **Merge** button to get the result.

![Merge Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Merge-Cells-Dialog-Box.png)<figcaption id="caption-attachment-19229">Merge Cells Dialog Box</figcaption>

- You will see that the selected columns have been merged as shown in the below figure.

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

## Steps to Merge Rows into One:

To join multiple rows into one in an Excel spreadsheet, follow the below instructions.

- First, you need to **select the input range** as shown in the below image.

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

- On the **Ablebits Data Tab, click** the **Merge Cells** option, then **select** the **Merge Rows into One** option from the menu.

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

- Then, it will display the **Merge Cells Dialog Box**.
- **How to merge – Select** the **rows into one** option.
- **Separate values with –** You need to **select**  **any separator** from the drop-down list.
- **Place the results to – Select** the **top row** option from the drop-down list.
- Finally, **click** the **Merge** button to get the result.

![Merge Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-12.png)<figcaption id="caption-attachment-19233">Merge Cells Dialog Box</figcaption>

- You can see the merged row as shown in the below screenshot.

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

## Merge Cells into One:

To combine multiple cells into one, do as follows.

- First, you need to **select the input range** as shown in the below image.

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

- Then, go to the **Ablebits Data Tab, click** the **Merge Cells** option, then **select** the **Merge Cells into One** option from the menu.

![Ablebits Data tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-10.png)<figcaption id="caption-attachment-19236">Ablebits Data tab</figcaption>

- Then, it will display the **Merge Cells Dialog Box**.
- **How to merge – Select** the **cells into one** option.
- **Separate values with –** You need to **select**  **any separator** from the drop-down list.
- **Place the results to – Select** the **bottom-right cell**  option from the drop-down list.
- Finally, **click** the **Merge** button to get the result.

![Merge Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-10.png)<figcaption id="caption-attachment-19237">Merge Cells Dialog Box</figcaption>

- At last, you can see the combined cell as shown in the below image.

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

## Wrap-Up:

In this article, you can easily understand the steps to **merge cells as you need** in **Excel Office 365** with **ablebits.** Kindly, leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!