How do you merge cells in Excel

The command used to merge cells in Excel is Merge & Centre. Many newbies who start using Excel recently ask me the question how do you merge cells in Excel? I smile always and reply to their question. I try to guide them properly. In this article, I will guide you also on the same question as you are searching the internet with the same issue. Keep reading our content.

What is merge in Excel?

This is the question that I ask them as well. What is merge in Excel? The answer is very simple. In Microsoft Excel, the merge is to combine two or more cells together. When you merge two or more cells together that will act like a single cell and that single cell can contain a single data. You cannot keep multiple data on that.

Why do you need to merge cells?

In addition to my first question, I ask them this question also. Why do you need to merge cells? Most of cases, they all reply with the same answer. Some want to add a heading to a table and center the text, some want to increase the cell width, etc., etc.

Whatever the cause is, they want to merge multiple cells. Yes, they need it

How do you merge cells in Excel?

Now come to the answer. How do you merge cells in Excel? You can do the task by using three methods.

• Using the command button in the ribbon.
• From Format Cells Options.

Using the command button in the ribbon

• Select the cells you want to merge or combine together.
• Go to the Home tab, and select the Merge and Center command button.
• All the cells that you have selected will be merged together.

From Format Cells Options

It is the second option to merge cells or combine two or more cells together.

• Select the cells you want to merge or combine together.
• Press Ctrl+1 on your keyboard to open the Format Cells box
• Alternatively, right-click and select Format Cells from the menu.
• Select the Alignment tab.

• Select the checkbox Merge Cells and click OK to complete the task.
• You are done.

What else you can do except Merge

There may arise some issues once you have merged a few cells in your table. One of them is  VLOOKUP does not work if there are any merged cells in a worksheet. Rather than this, I do not like to merge cells in a worksheet. But is there any alternative to this?

Wait, there is a simple task you can do that can also serve your purposes. Let me check and explain to you.

• Select the cells again, if you do not mind.
• Press Ctrl+1 on your keyboard to open the Format Cells box
• Alternatively, right-click and select Format Cells from the menu.
• Select the Alignment tab.
• Click the Horizontal drop-down menu and select Center Across Selection and click OK to complete the task.

• And it is done, I think. Please check the screenshot again.

Benefits of merging cells

In most cases, users want to add a heading to a table and that is the basic reason behind merging cells. Merge and Center command offers to center the text also. Not only in a horizontal direction you can merge cells in the vertical direction and both columns and rows together.

Read More: How to find the smallest number in Excel

How to unmerge cells

If you learn to merge cells together, you should learn how to unmerge cells again. It is also simple as merging cells. Follow the steps below to do it with a click only.

Select the merged cells with the help of your mouse or keyboard shift + arrow then follow any options below.

Using the command button in the ribbon

• Go to the Home tab, and select the Merge and Center command button.
• Select Unmerge Cells.
• All the cells that you have selected will be merged together.

From Format Cells Options

• Press Ctrl+1 on your keyboard to open the Format Cells box
• Alternatively, right-click and select Format Cells from the menu.
• Select the Alignment tab.
• Uncheck the checkbox Merge Cells.
• Your merged cells are now unmerged.

I hope, this article on how to merge cells in excel is really helpful for the newbies. If you also think the same as I am thinking, please post a comment in the comment box. Thank you for being with us.