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 rows and columns together, etc. In this article, you will learn 4 different ways that you can use to merge columns in Excel with ease.
Below we have the dataset where we used the Merge and & Center from the Alignment group in the Home tab. After the command button is clicked, cell B4 and cell C4 are now merged. We are going through various processes similar to this to merge multiple columns in Excel.
Download Practice Workbook
You are recommended to download the Excel file and practice along with it.
4 Easy 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 at the dataset:
So, without having any further discussion let’s dive straight into all the methods one by one.
1. Using Merge & Center Command to Merge Columns in Excel
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.
- Then go to Home ▶ Alignment ▶ Merge & Center.
- After that, from the drop-down menu select Merge & Center.
- After you are done with the previous steps, you will see the result finally.
💡 Note:
Read More: How to Merge Two Columns in Excel Without Losing Data
2. Use of Merge Across Command to Combine Columns in Excel
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.
- Then go to Home ▶ Alignment ▶ Merge & Center.
- After that from the drop-down menu select Merge Across.
- Finally, after you are done with the previous steps, you will see the result as follows:
💡 Note:
Read More: How to Merge Two Columns in Excel With a Space
3. Blend Multiple Columns Using Merge Cells Command 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:
- At first, select the range of cells ▶ to merge them together.
- Then go to Home ▶ Alignment ▶ Merge & Center.
- Moreover from the drop-down menu select Merge Cells.
- Finally, when you are done with all the steps mentioned above, you will see the result as follows:
💡 Note:
Read More: How to Join Two Columns in Excel (5 Easy Methods)
4. Adjacent Columns United by Using Format Cells Command
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:
- At first, select the range of cells ▶ to combine them together.
- After that press CTRL + 1 to open up the Format Cells dialog box.
- After that go to the Alignment tab.
- then mark tick on the Merge Cells option under the Text Control menu.
- After that, finish the whole process by hitting the Ok option.
- Finally when you are done with all the steps above, you will see the result as follows:
Read More: How To Merge Two Columns In Excel (6 Easy Ways)
How to Unmerge Columns
To unmerge columns in Excel, simply press CTRL + Z buttons or go through the following steps,
- At first, select the merged cells.
- Go to Home ▶ Alignment ▶ Merge & Center ▶ Unmerge Cells.
- Finally, after clicking on the Unmerge Cells command, we can see that the range of cells B7:C8 is now unmerged and available to edit.
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.