Can Excel Tables Include Merged Cells? Formatting Solutions
Question details
The user wants to know if Excel tables support merged cells and how to properly format grouped headers or combined data without breaking table functionalities.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating an Excel table from a dataset that currently contains grouped headers, model numbers, and descriptions arranged using merged cells.
- Observed behavior
- Excel tables and merged cells are mutually incompatible, preventing users from creating structured tables or causing errors when attempting to format merged data.
Before unmerging cells or restructuring your layout, inspect your dataset to identify which columns might need duplicating or combining so you do not lose context.
Unmerge Cells and Ensure a Standard Grid Layout
This is the primary method to make your dataset compatible with Excel tables. You must remove all merged cells so that every row and column contains individual data points.
Excel tables rely on a strict grid structure to enable features like sorting, filtering, and structured references. Merging cells breaks this uniform grid, which is why it is completely prohibited inside an active Excel Table.
Highlight the entire range of your dataset that contains the merged cells.
Navigate to the 'Home' tab on the Excel ribbon, click the drop-down arrow next to 'Merge & Center', and select 'Unmerge Cells'.
Since unmerging leaves blank cells, fill those empty cells with the appropriate repeated data or headers so your dataset remains accurate.
Select the cleaned data range and press 'Ctrl + T' (or go to Insert > Table) to successfully convert your standard grid into an Excel table.

Use 'Center Across Selection' for Visual Headers
If you need a heading to look like it spans across multiple columns (like a merged cell) but want to keep it outside or above the table without breaking structure, use Center Across Selection.
Combine Data Using a Helper Formula
Instead of visually merging a model number and a description into a single large cell, you can combine the text into one column using an Excel formula.
Easily Manage Tables and Formatting with WPS Spreadsheet
Organizing complex datasets and handling formatting limitations is effortless with WPS Spreadsheet. You can quickly unmerge cells, apply 'Center Across Selection', and create structured tables with full compatibility with Microsoft Excel formats.
- 1. Open your workbook: Launch WPS Spreadsheet and open the document containing the merged cells.
- 2. Unmerge data: Select the merged areas, go to the Home tab, and click 'Merge and Center' to unmerge them instantly.
- 3. Apply centering: Highlight header cells, right-click to choose 'Format Cells', and select 'Center Across Selection' under the Alignment tab.
- 4. Insert your table: Select your newly organized grid and click 'Insert' > 'Table' to unlock advanced data management tools.

Frequently Asked Questions
Why does Excel show an error when I try to create a table with merged cells?
Excel tables require a consistent database structure where every row is a unique record and every column is a unique field. Merged cells disrupt this grid, making it impossible for Excel to accurately sort, filter, or apply structured formula references to the data.
Can I merge cells after an Excel table is already created?
No. When you click inside an active Excel table, you will notice that the 'Merge & Center' button on the Home tab is grayed out and disabled. To merge cells, you must first convert the table back into a normal range (Table Design > Convert to Range).
How do I easily find all merged cells in a large worksheet?
Press 'Ctrl + F' to open the Find dialog, click 'Options', then click the 'Format' button. Go to the 'Alignment' tab, check the box for 'Merge cells', and click 'OK'. When you click 'Find All', Excel will display a list of every merged cell in your worksheet so you can easily navigate and unmerge them.




