How to Merge Columns in Excel (4 Ways)

To merge columns is one of the most basic tasks that we need to perform while working with data in Excel. Fortunately, Excel has come up with multiple features that enable us to merge columns as per our requirements. We can merge columns and put the data at the center, merge across columns, merge columns and rows together, etc. In this article, you will learn 4 different ways that you can use to merge columns in Excel with ease.


Download the Practice Workbook

You are recommended to download the Excel file and practice along with it.


4 Ways to Merge Columns in Excel

In this article, we will be using a sample product price list as a dataset to demonstrate all the methods. So, let’s have a sneak peek of the dataset:

dataset for 4 Ways to Merge Columns in Excel

So, without having any further discussion let’s dive straight into all the methods one by one.


1. Merge Columns in Excel Using Merge & Center

We can merge multiple columns and put the data within them at the center of the merged columns. This type of column merging is super useful and can be used for title showcasing. So, let’s see how we can do it in Excel.

🔗 Steps: 

❶ First of all, select the range of cells ▶ to merge them together.

❷ Go to Home ▶ Alignment ▶ Merge & Center.

❸ From the drop-down menu select Merge & Center.

Merge Columns in Excel Using Merge & Center

That’s it.

After you are done with the previous steps, you will see the result as follows:

merge and center

💡 Note:

This method is suitable for title showcasing.


2. Combine Columns in Excel Using Merge Across

If you want to merge cells within a single row, then you can use this option. Here’s how to do it step-by-step:

🔗 Steps:

❶ First of all, select the range of cells ▶ to merge them together.

❷ Go to Home ▶ Alignment ▶ Merge & Center.

❸ From the drop-down menu select Merge Across.

That’s it.

Combine Columns in Excel Using Merge Across

After you are done with the previous steps, you will see the result as follows:

merge across

💡 Note:

The Merge Across command can merge cells within a single row only. It can’t merge cells in a range of rows.


3. Merge Columns Using Merge Cells in Excel

If you need to merge cells both in a range of columns as well as rows then you can use the Merge Cells command. Now follow the steps below to see how it works:

🔗 Steps:

❶ First of all, select the range of cells ▶ to merge them together.

❷ Go to Home ▶ Alignment ▶ Merge & Center.

❸ From the drop-down menu select Merge Cells.

That’s it.

Merge Columns Using Merge Cells in Excel

When you are done with all the steps mentioned above, you will see the result as follows:

💡 Note:

The Merge Cells command can combine cells both in a range of columns and rows.


4. Combine Columns Using Format Cells

In this section, we will combine columns with the help of the Format Cells feature in Excel. Now follow the steps below to see how it works:

🔗 Steps:

❶ First of all, select the range of cells ▶ to combine them together.

❷ After that press CTRL + 1 to open up the Format Cells dialog box.

❸ Go to the Alignment tab.

❹ Now mark tick on the Merge Cells option under the Text Control menu.

❺ Finally, finish the whole process by hitting the Ok option.

Combine Columns Using Format Cells

When you are done with all the steps above, you will see the result as follows:


How to Unmerge Columns

To unmerge columns in Excel, simply press CTRL +  Z buttons or go through the following steps,

❶ Select the merged cells.

❷ Go to Home ▶ Alignment ▶ Merge & Center ▶ Unmerge Cells.

Unmerge Columns

That’s it.


Things to Remember

📌 Press CTRL + 1 button to open up the Format Cells dialog box.

📌 You can Press the CTRL + Z buttons to unmerge columns right after merging them together.


Conclusion

To sum up, we have discussed 4 ways, to merge columns in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.


Read More

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo