How to Merge Cells in Excel Table (7 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Merge Cells in an Excel Table: 7 Quick Ways

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


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


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


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

Read More: How to Merge Datasets in Excel


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 activate 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 the 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


Download Practice Workbook

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


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.


<< Go Back to Cells | Merge | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bhubon Costa
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo