Pivot Table Tabular Form: What It Means and How to Use It

Updated 5 November 2026 · Standard formula, shown below

A pivot table in tabular form displays each row-field value in its own column, rather than nesting lower-level labels beneath higher-level ones. In Excel, this layout can make a report easier to scan, filter, copy, and use as a source for other analysis; it changes the presentation, not the underlying summary calculations.

What tabular form means

Pivot tables summarize records by categories and calculate values such as sums, counts, or averages. A report might group sales first by region and then by salesperson. In a compact layout, the salesperson can appear indented inside the region column. In tabular form, Region and Salesperson appear as separate columns.

That distinction matters when you want a table that resembles a conventional data grid. Each displayed record has a separate field for each row grouping, so readers can identify the category values without interpreting indentation or blank-looking hierarchy levels. Tabular form is a layout choice; it does not mean the pivot table stops being a pivot table.

How to show a pivot table in tabular form

In desktop Excel, click inside the pivot table to display its contextual PivotTable tools. Then use the Design tab and its Report Layout menu:

Select a cell in the pivot table.
Open Design under PivotTable Tools.
Select Report Layout, then Show in Tabular Form.

The row fields should now occupy separate columns. The exact ribbon appearance can vary with the Excel version and window size, but the command is part of the pivot table’s report-layout controls. If the contextual tabs are not visible, first check that the selected cell is inside the pivot table rather than beside it.

Repeat labels and blank cells

Switching to tabular form does not necessarily fill every repeated category label down the report. To show the label on each applicable row, choose Report Layout > Repeat All Item Labels. This is useful when people will sort or copy the displayed results, or when the report will be read outside Excel.

Repeated labels are display values, not evidence of duplicated source records. For example, if a region has three salesperson rows, the region name may be printed three times so each row stands alone. Without repeated labels, some cells may look blank because the pivot table suppresses redundant labels for visual compactness.

Tabular layout and repeated labels are separate settings. Choose the first to put row fields in separate columns; choose the second if you also want labels repeated. Depending on the report and Excel version, you may also see an option to repeat labels for selected fields rather than all of them.

Tabular, compact, and outline layouts

Excel’s report layouts arrange row fields in different ways. None changes the source data or, by itself, changes the aggregation used for values.

Compact form: Places multiple row fields in one column, using indentation to communicate hierarchy. It saves horizontal space and is often the default.
Outline form: Gives row fields separate columns, with a more explicitly hierarchical report appearance. Subtotals can be displayed at the top or bottom of groups.
Tabular form: Gives each row field its own column in a grid-like arrangement. It is often convenient for reading, filtering, or copying the displayed report.

Tabular and outline forms can look similar because both separate row fields into columns. Their appearance also depends on subtotal and label settings. If the purpose is a straightforward, flat-looking report, tabular form with repeated labels and appropriate subtotal settings is usually the combination to consider.

Subtotals, totals, and practical uses

Changing the layout does not automatically remove subtotals or grand totals. A report can remain grouped and show subtotal rows even when its row fields are in separate columns. To adjust them, use the Design tab’s Subtotals and Grand Totals controls. Available choices depend on the layout and the structure of the pivot table.

For example, a sales summary with Region and Salesperson as row fields and Sum of Revenue as its value could have columns for Region, Salesperson, and Revenue. Tabular form makes it clear which salesperson belongs to which region, especially if labels repeat. If the report includes a subtotal after each region, those subtotal rows remain a separate reporting feature.

This layout is useful when you need to:

Read several row categories side by side instead of following indentation.
Filter or sort separate row-field columns in the displayed report.
Copy a summary into another document or use it as a human-readable report.
Make category labels explicit for readers unfamiliar with compact pivot tables.

A pivot table is still a summary, not a replacement for the original row-level dataset. If you need a clean, fully normalized data table for a database import or a repeatable downstream process, check the copied output carefully and consider working from the source data instead.

Common problems and misconceptions

The command is missing: Select a cell inside the pivot table so Excel displays its PivotTable tools. The command is not normally available as a report-layout option for an ordinary range.
Some category cells look blank: Use Repeat All Item Labels if you want labels on every displayed row. A blank-looking repeated label does not necessarily mean the source value is missing.
Subtotal rows remain: Tabular form controls field placement, not whether subtotals are shown. Change subtotal settings separately if needed.
The report still looks hierarchical: Check whether multiple row fields are present and whether subtotals, blank rows, or other formatting are creating the appearance. Tabular form does not flatten the source data into individual records.
The values are not the expected ones: Layout changes do not choose the calculation. Check the value field’s summary method, such as Sum, Count, or Average, and refresh the pivot table if its source data has changed.

A common misconception is that “tabular form” means converting a pivot table into a plain Excel table. It does not: the result remains a pivot table with interactive fields and summary behavior. Another is that separate columns guarantee a tidy export. Filters, subtotals, grand totals, and repeated labels can all affect the copied result.

Frequently Asked Questions

How do I change a pivot table to tabular form?
Click inside the pivot table, open PivotTable Tools’ Design tab, select Report Layout, and choose Show in Tabular Form.

How do I repeat labels in a pivot table?
On the Design tab, choose Report Layout and then Repeat All Item Labels. This repeats row-field labels in the displayed report.

Does tabular form change the pivot table’s calculations?
No. It changes how fields are arranged on the sheet. The value field’s calculation and the source records are separate from the report layout.

What is the difference between tabular and compact form?
Compact form places row fields in one column with indentation. Tabular form puts each row field in a separate column, making the categories visible side by side.

Can I remove subtotals after switching to tabular form?
Yes. Use the Design tab’s Subtotals control to choose how subtotals appear or turn them off. This setting is independent of the choice to show fields in tabular form.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.