Formatting Issues

Can Excel Tables Include Merged Cells? Formatting Solutions

Nimra MalikNimra Malik Nov 10, 2026 869 views

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.

Can Excel Tables Include Merged Cells? Formatting Limitations Explained
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 you start

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.

Solution 1Recommended

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.

1
Select the merged data

Highlight the entire range of your dataset that contains the merged cells.

2
Unmerge the cells

Navigate to the 'Home' tab on the Excel ribbon, click the drop-down arrow next to 'Merge & Center', and select 'Unmerge Cells'.

3
Fill empty cells

Since unmerging leaves blank cells, fill those empty cells with the appropriate repeated data or headers so your dataset remains accurate.

4
Convert to Table

Select the cleaned data range and press 'Ctrl + T' (or go to Insert > Table) to successfully convert your standard grid into an Excel table.

Unmerge Cells and Ensure a Standard Grid Layout
Pro Tip: To quickly fill blank cells after unmerging, select the column, press 'F5' > 'Special' > 'Blanks', type '=' and select the cell above, then press 'Ctrl + Enter'.
Professional Spreadsheet Solution

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. 1. Open your workbook: Launch WPS Spreadsheet and open the document containing the merged cells.
  2. 2. Unmerge data: Select the merged areas, go to the Home tab, and click 'Merge and Center' to unmerge them instantly.
  3. 3. Apply centering: Highlight header cells, right-click to choose 'Format Cells', and select 'Center Across Selection' under the Alignment tab.
  4. 4. Insert your table: Select your newly organized grid and click 'Insert' > 'Table' to unlock advanced data management tools.
Seamlessly compatible with Microsoft Excel (.xlsx) file formats.Intuitive right-click menus for quick unmerging and alignment formatting.Robust table features for sorting, filtering, and managing complex datasets.Free to use, lightweight, and incredibly fast even with large files.
microsoft office alternative - wps office

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.