How to Merge Cells in Excel Table (7 Ways)

One of the most general uses utilized by beginner excel users is merging cells. However, they have several disadvantages that make them a poor choice. I’ll show you all you need to know about merged cells in this post, including 7 different techniques to merge cells in an Excel table.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


7 Quick Ways to Merge Cells in an Excel Table

Consider the following data set where a list of names is placed. But for a better understanding, you need to merge the cells. In the sections below, we’ll demonstrate how to merge the cells with various examples including VBA code.

Merge Cells in Excel Table

1. Apply the Merge & Center Command to Merge Cells in Excel Table

It’s the most popular way of merging cells. Follow the instructions below to merge cells using the Merge & Center Command.

Apply the Merge & Center Command to Merge Cells in Excel Table

Step 1:

  • Firstly, select the cells.

Apply the Merge & Center Command to Merge Cells in Excel Table

Step  2:

  • From the Home Tab, Select the Merge & Center

Apply the Merge & Center Command to Merge Cells in Excel Table

Therefore, you will see that cells B4:B9 are merged.

Apply the Merge & Center Command to Merge Cells in Excel Table

Read more: How to Merge and Center Cells in Excel


2. Use Keyboard Shortcut to Merge Cells in Excel Table

Using the keyboard shortcut to merge cells is an underappreciated but simple way. Follow the instructions below to do so.

Steps:

  • To merge the cells, select the cells at first.
  • Press  Alt H a and release then.
  • Finally, press  M + M .

Use Keyboard Shortcut to Merge Cells in Excel Table

As a result, your required cells will be merged.

Use Keyboard Shortcut to Merge Cells in Excel Table

Notes. Don’t press Alt + H + M + M at a stretch, first press Alt + H and then M + M after release.

Read more: How to Merge Cells in Excel with Data


3. Merge Cells in Excel Table Using Format Cells

Format cells can also be used to merge cells. You may do so by using the Alignment option in the Format Cell Dialog Box. Format Cells will guide you through the processes to merge cells as described in the steps below.

Merge Cells in Excel Table Using Format Cells

Step 1:

  • Press Ctrl + 1 to open the Format Cell Dialog Box.
  • Choose the Alignment
  • Mark the Merge cells

Merge Cells in Excel Table Using Format Cells

Step 2:

  • Press Enter to see the results.

Merge Cells in Excel Table Using Format Cells

Read more: How to Merge Text Cells in Excel


4. Apply the Copy & Paste Option to Merge Cells

When you need to duplicate the same column or row width, you may use the Copy & Paste method.

Apply the Copy & Paste Option to Merge Cells in Excel Table

Step 1:

  • Firstly, select the cells.
  • Press Ctrl + C to copy.

Apply the Copy & Paste Option to Merge Cells in Excel Table

Step 2:

  • To paste press Ctrl + V in the required location.

Apply the Copy & Paste Option to Merge Cells in Excel Table

Consequently, you will obtain the result as shown in the below screenshot.

Apply the Copy & Paste Option to Merge Cells in Excel Table


Similar Readings


5. Run a VBA Code to Merge Cells in Excel Table

Additionally, you can merge cells by applying the VBA code. To see the procedure, follow the steps below.

Step 1:

  • To active the VBA Macro-Enabled worksheet, press Alt + F11.
  • Click on the Insert option from the tab.
  • Select the Module from the options available.

Run a VBA Code to Merge Cells in Excel Table

Step 2:

  • Paste the following VBA
Sub MergeCells_Names()
Range("B4:B9").Merge
End Sub

Run a VBA Code to Merge Cells in Excel Table

Therefore, you will get the following result.

Run a VBA Code to Merge Cells in Excel Table


6. Merge Cells in Excel Inside a Pivot Table

After constructing a Pivot Table, you may need to merge cells. However, if you are unfamiliar with the method, you must recreate the Pivot Table. So, to make things easy, simply follow the steps.

Step 1:

  • Select a cell in the Pivot Table.

Inside a Pivot Table

Step 2:

  • Select Design from the tab.
  • Then, choose the Report Layout

Inside a Pivot Table

Step 3:

  • Choose the Show in Tabular Form

Inside a Pivot Table

Step 4:

  • Go to PivotTable Analyze and select the Options

Inside a Pivot Table

Step 5:

  • After opening the box, go Layout & Format
  • Mark the check box named with Merge and Center cells with labels.
  • Finally, press Enter.

Inside a Pivot Table

  • Therefore, you will get the result as shown in the below image highlighted by yellow color.

Inside a Pivot Table


7. Merge Multiple Ranges of Cells at a Time in Excel Table

Merge multiple cells is one of the easiest tasks to do. Just follow the steps described.

Step 1:

  • Select cells at once.
  • Hold the Ctrl button and continue to select cells you want to merge.

Multiple Ranges of Cells

Step 2:

  • Click on the Merge & Center

Multiple Ranges of Cells

Therefore, you will have multiple cells merged at once.

Multiple Ranges of Cells


Conclusion

To summarize, I hope that this post has shown how to merge cells in an Excel table. Examine the practice book and apply what you’ve learned. Because of your support, we are willing to repay projects like this.

Please do not hesitate to contact us if you have any queries. Please leave a comment below to let me know what you think.

Exceldemy experts will respond to your inquiries as quickly as possible.


Further Readings

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo