Bhubon Costa
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.
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: [Fix:] Excel Unable to Merge Cells in 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 at 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 Text Cells in Excel (9 Simple Methods)
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 Text from Two or More Cells into One Cell (Easiest 6 ways)
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 Two Cells in Excel Without Losing Data (2 Ways)
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.
Step 2:
- Paste the following VBA
Sub MergeCells_Names()
Range("B4:B9").Merge
End Sub
Therefore, you will get the following result.
Read More: Merge Data in Excel from Multiple Worksheets (3 Methods)
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.
Read More: How to Merge Text from Two Cells in Excel (7 Methods)
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.
Step 2:
- Click on the Merge & Center
Therefore, you will have multiple cells merged at once.
Read More: How to Merge Multiple Cells without Losing Data in Excel (6 Methods)
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.
