No. An Excel Table can have only one header row: the first row of the table range supplies one label for each column. To show grouped or tiered headings, place those headings above the table and keep a single, clearly labeled row inside it.
How an Excel Table header works
In Excel for Microsoft 365 on Windows, a table’s header row gives each column its field name. Those names appear in the table’s filter buttons and are used in structured references, which let formulas refer to columns by name rather than by cell address. For example, a formula can refer to a table column named Sales instead of using a range such as C2:C100.
When you create a table, Excel treats the first row of the selected range as the header if you select the “My table has headers” option. If you leave that option unchecked, Excel creates its own header labels. A table header is still one row even if a label wraps onto several lines within its cell; that is different from having two separate header rows.
Each column needs a usable, distinct name. Empty or duplicate headings can be changed or supplemented by Excel so that the table has column names it can use. It is better to provide concise, unique labels yourself, such as Region, Product, and Q1 Sales, than to rely on automatically generated names.
Why tables do not support multiple header rows
A table is designed as a rectangular dataset: one record per row and one field per column. A single header row makes it possible for Excel to identify those fields consistently when you sort, filter, add rows, create formulas, or use the data in tools such as PivotTables. With multiple heading levels, Excel would have to decide which row supplies the column name and how the other rows relate to the data.
That structure is why a merged group label such as “Quarter 1” spanning three columns does not work as a second table-header tier. Merged cells are not supported as part of an Excel Table’s data area, and table headings cannot be arranged as multiple rows. A visually attractive report layout may be useful for reading, but it is not necessarily a good structure for data operations.
This does not mean Excel cannot display a two-level heading. It means the extra level belongs outside the table, or the report should use a different feature, such as a PivotTable, when that feature suits the task.
Show grouped headings above the table
For a report that needs grouped labels, keep the group headings in ordinary worksheet cells above the table and make the table start on the next row. For instance, a sales report could use a title row, then a group row with “First quarter” above three month columns, then a table header row with Month, January, February, and March—or, more usefully for a data table, one row with fields such as Region, Product, Month, and Sales.
If the goal is presentation rather than data analysis, a layout like this can work:
- Put a report title in a row above the table.
- Put optional group labels in another row above the table, using merged cells only in that area if necessary.
- Start the table at the next row with one unique heading for every column.
- Use cell formatting, borders, fill colors, or wrapped text to make the group labels visually distinct.
Keep the data rows directly below the table’s one header row, with one value per field. Avoid putting subtotals, explanatory notes, or blank separator rows inside the table. Those items can interrupt sorting and filtering or be treated as records. If you need grouped labels repeated in the actual data, store the category as a value in each relevant row rather than relying on a merged heading.
Create a table with one header row
On Windows, select a cell in a contiguous range that has one heading row and choose Insert > Table. Ctrl+T is also a shortcut for opening the Create Table dialog. Check that the selected range includes the data and its single header row, select “My table has headers,” and choose OK. On Mac, use Insert > Table if the shortcut differs with your keyboard settings.
After creation, Excel adds filter controls to the header cells and applies a table style. Selecting a cell in the table exposes the Table Design tab in the ribbon. Its options include controls for the header row and total row, along with table styles. The Total Row option adds a summary row at the bottom; it does not add another header row at the top.
To make labels easier to read, use Wrap Text or adjust column width and row height. A long heading can occupy more than one visual line within its single header cell, while remaining one field name. For example, “Units returned after delivery” can wrap across several lines without changing the table structure.
Convert a report with multiple heading rows
Imported spreadsheets and exported reports often begin with a title, date range, or category bands before the actual column names. Before turning such a range into a table, identify which row contains the real field names. Move the title or group labels outside the data range, then create the table from the field-name row through the last record.
For example, suppose a worksheet has “2026 Regional Sales” in row 1, “North” merged across several columns in row 2, column labels in row 3, and records below. Do not include all three heading rows in the table range. Keep the report title and any visual group labels above the table, and use row 3 as the table’s sole header row. If the merged labels represent information needed for analysis, add that information as a normal field in each record instead.
For repeatable cleanup of imported files, Power Query can help. Load the data into the Power Query Editor, remove title or introductory rows that are not part of the records, and promote the correct first row to headers. Check the result before loading it back to Excel: every column should have a meaningful heading, and each row should represent one record. A report with cross-tabulated headings may need reshaping, such as unpivoting columns, before it becomes a useful table.
Repeat headings when printing
A common source of confusion is the difference between multiple table-header rows and repeating a heading on printed pages. A worksheet can repeat selected rows at the top of each printed page without making those rows part of the table. In desktop Excel, use Page Layout > Print Titles, then set the rows in “Rows to repeat at top.” This is a print setting, not a change to the table’s structure.
For example, a report can have a title and group heading above the table on the first page, while the table itself has one header row. If readers need the column labels on later printed pages, set the table’s header row as the repeating print row. Check Print Preview because page breaks and the placement of the title can affect how the report looks. Excel for the web has fewer page-layout controls than the desktop application, so use desktop Excel when you need to configure print titles.
When a PivotTable is a better fit
If you want Excel to generate nested labels from categories, a PivotTable may be more appropriate than a standard table. For example, placing Year and Month as row fields can display a hierarchy in which months are grouped under years. PivotTables can also arrange fields across columns and summarize values, which is useful for a report view that changes as you filter or rearrange fields.
A PivotTable is not simply a regular table with another header row. It is a summary report built from source data, and its layout and labels depend on its fields and layout settings. Keep the underlying source as a clean, one-header-row table when possible, then build a PivotTable for grouped summaries. If you need a flat list for formulas, exports, or further data processing, use the source table rather than treating the PivotTable’s displayed hierarchy as a standard dataset.
Common problems and practical fixes
- The first data record became a heading: When creating the table, ensure the selected range starts with the actual column-label row and select “My table has headers.” If Excel already created the table incorrectly, edit the header cells and check that the first record remains in the table body.
- Excel changed a repeated or blank heading: Give every column a distinct, nonblank name before creating the table. Descriptive labels reduce confusion in filters and formulas.
- A group heading disappears from filtering: Group headings outside the table are presentation labels, not filter fields. Add a field to the data rows if the group is information users need to filter or analyze.
- Sorting separates related records: Sort the table by a field, not a fragment of the worksheet. Keeping each record on one table row lets Excel move its related values together.
- The heading looks like two rows: Check whether text is merely wrapped inside a tall header cell. A wrapped label is still one table header; two worksheet rows of labels are not.
Frequently Asked Questions
Can I add a second header row to an Excel Table?
No. A standard Excel Table has one header row. Put extra labels above the table, or use a PivotTable if you need a generated hierarchy for a summary report.
Can I merge cells in an Excel Table header?
No. Merged cells are not supported within the table’s data area. You can merge cells in ordinary worksheet rows above the table, but keep each table column’s heading in its own cell.
Can one table header use two lines of text?
Yes. Wrap the text in a single header cell or adjust its row height. Multiple visual lines within one cell do not create multiple header rows.
Can I repeat the table header on every printed page?
Yes. In desktop Excel, use Page Layout > Print Titles and specify the header row under “Rows to repeat at top.” This repeats the row for printing; it does not add another table header.
Should I use a PivotTable for two-level headings?
Use a PivotTable when you want a dynamic summary with nested categories, such as months grouped under years. Use a regular table for the underlying records and a single set of field names.
Related
- Data Validation Multiple Selection in Excel: What Works
- Data Validation Interview Questions and Strong Answers
- Data Validation Greyed Out in Excel? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Time Clock: Track Shifts, Breaks, and OvertimeAn Excel time clock is a workbook for recording employees’ clock-in and clock-out times, calculating shift hours, and…
- How to Add a Drop-Down in Excel Using Keyboard ShortcutsTo add a drop-down in Excel for Microsoft 365 on Windows, select the cell or cells, press Alt+D,…
- How to Archive Multiple Emails in OutlookTo archive several emails in Outlook, select the messages in your inbox or another mail folder, then choose…
- Rows Excel Shortcut: Insert, Delete, and Select RowsIn Excel for Microsoft 365 on Windows, select a whole row and press Ctrl+Shift+Plus to insert a new…
- How to Change Zoom in OutlookTo change the size of an email in classic Outlook for Windows, open the message in its own…
- How to Track Finances in Google Sheets Step by StepTo track finances in Google Sheets, create a transaction log, record each income or expense on its own…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.