How to merge cells in a range formatted as table in Excel?
In Excel, you can easily merge some consecutive cells into one with the Merge & Center utility as below screenshot shown. However, it cannot merge the cells in a range which formatted as a table in Excel, is there any trick to handle it?
Compare ways to merge cells from an Excel table
Merge same cells with Kutools for Excel
Compare ways to merge cells from an Excel table
Excel tables do not support merged cells, so the table must first be converted to a normal range before cells can be merged. After conversion, you can either use Excel's Merge & Center command for specific cells or use Kutools for Excel when you need to efficiently merge adjacent cells containing the same values.
| Method | Best for | What it merges | Key consideration |
|---|---|---|---|
| Convert to Range + Merge & Center | Merging specific cells after removing the Excel table structure | Any selected consecutive cells | Requires converting the table to a normal range and manually selecting and merging cells |
| Kutools for Excel | Quickly merging adjacent duplicate values in a normal range | Adjacent cells containing the same value across selected columns | Processes matching adjacent cells automatically without repeatedly selecting and merging each group |
Merge cells in a table
In Excel, there is no way that can merge cells in a table, but here I introduce a roundabout trick for you to merge cells in a table.
Select the table, the go to the Design tab, click Convert to Range, and then click Yes in the popping dialog to convert the table to a range which also looks like a table. See screenshot:
 |
 |
Then select the cells you want to merge, click Home > Merge & Center, and click OK in the popping out warning dialog. See screenshot:
 |
 |
Merge same cells with Kutools for Excel
If your data has been converted to a normal range and you need to merge adjacent cells containing the same values, Kutools for Excel provides a more convenient solution. Its Merge Same Cells feature can automatically merge adjacent identical values across selected columns, while Unmerge Cells & Fill Value can reverse merged cells and fill the resulting cells with the original value.
After installing Kutools for Excel, please do as below:
Select cells you want to operate, and click Kutools > Merge & Split > Merge Same Cells or Unmerge Cells & Fill Value. See screenshot:
Merge same cells or unmerge cells:
Demo: Quickly Merge Adjacent Cells In Columns With Same Data/Value In Excel
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in