Mrinmoy
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:
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.
That’s it.
After you are done with the previous steps, you will see the result as follows:
đź’ˇ 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.
After you are done with the previous steps, you will see the result as follows:
đź’ˇ 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.
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.
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.
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.
