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.
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.
Step 1:
- Firstly, select the cells.
Step 2:
- From the Home Tab, Select the Merge & Center
Therefore, you will see that cells B4:B9 are merged.
Read More: How to Merge Multiple Cells in Excel at Once
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 .
As a result, your required cells will be merged.
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 Multiple Cells without Losing Data in Excel
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.
Step 1:
- Press Ctrl + 1 to open the Format Cell Dialog Box.
- Choose the Alignment
- Mark the Merge cells
Step 2:
- Press Enter to see the results.
Read More: How to Merge Cells Vertically Without Losing Data 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.
Step 1:
- Firstly, select the cells.
- Press Ctrl + C to copy.
Step 2:
- To paste press Ctrl + V in the required location.
Consequently, you will obtain the result as shown in the below screenshot.
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.
Step 2:
- Paste the following VBA
Sub MergeCells_Names()
Range("B4:B9").Merge
End Sub
Therefore, you will get the following result.
Read More: How to Merge Text from Two Cells in Excel
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.
Step 2:
- Select Design from the tab.
- Then, choose the Report Layout
Step 3:
- Choose the Show in Tabular Form
Step 4:
- Go to PivotTable Analyze and select the Options
Step 5:
- After opening the box, go Layout & Format
- Mark the check box named with Merge and Center cells with labels.
- Finally, press Enter.
- Therefore, you will get the result as shown in the below image highlighted by yellow color.
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.
Step 2:
- Click on the Merge & Center
Therefore, you will have multiple cells merged at once.
Read More: How to Merge Data from Multiple Workbooks in Excel
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.