Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Merge Columns in Excel (4 Easy 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 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.

Merge Columns in Excel Using Merge & Center Command from the alignment group in Home tab


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:

Sample 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.

Using Merge & Center Command to Merge Columns in Excel

  • After you are done with the previous steps, you will see the result finally.

Cell B4 and Cell C4 merged to become a single cell

💡 Note:

  • This method is suitable for title showcasing.

 

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.

Use of Merge Across Command to Combine Columns in Excel 

  • Finally, after you are done with the previous steps, you will see the result as follows:

Cell B6 and C6 are now combined using the merge across command

   

💡 Note:

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

 

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.

Merge Columns Using Merge Cells command in Excel

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

Rows are now combined by using the Merge Cells command

💡 Note:

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

 

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.

Columns Combine Using Format Cells command

  • 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.

cell alignemnt fixng in format cells dialog box

  • Finally when you are done with all the steps above, you will see the result as follows:

after the settings alignment fix dialog box, we can see that cell B5 and cell C5 is now merged

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.

Columns Unmerged using the Unmerge cells command in alignment group on Home tab

  • 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.

range of cell B7:C8 is now unmerged


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.


Related Articles

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