Insert a Row in an Excel PivotTable: Steps and Fixes

To add a row to an Excel PivotTable, click inside it, select PivotTable Analyze > Field List, then drag the field you want into the Rows area of the PivotTable Fields pane. If you mean adding a new record to the PivotTable’s source data, add it to the source first and refresh the PivotTable; those are two different operations.

What “insert a row” can mean

Excel PivotTables summarize source data rather than storing a separate, editable copy of every result. That is why “insert a row” can refer to several different tasks:

Add a category or label to the report: Put a field such as Region, Product, or Month in the Rows area. Excel creates row labels for the distinct items in that field.
Include a new source record: Add a record to the underlying data, then refresh the PivotTable so Excel can include it in the summary.
Show an empty line between groups: Use the PivotTable’s layout options to insert blank lines after items. This changes the report’s appearance; it does not create a new data record.
Insert an ordinary worksheet row: This is a worksheet editing action, not a way to add a PivotTable result. Editing or shifting cells inside the PivotTable itself can be blocked or cause layout problems.

Identifying which of these you need makes the right steps much clearer. In most cases, someone asking how to insert a row wants to add a field to the Rows area or include a new record in the source.

Add a field to the Rows area

Use these steps in Microsoft Excel for Microsoft 365 on Windows to add a row field:

Click any cell inside the PivotTable. The contextual PivotTable Analyze and Design tabs should appear on the ribbon.
Select PivotTable Analyze > Field List if the field pane is not already visible.
In the PivotTable Fields pane, find the field whose items should appear down the report. For example, choose Region to create a row for each region.
Drag the field into the Rows box at the bottom of the pane. If the pane shows areas labeled Filters, Columns, Rows, and Values, place it specifically in Rows.

Excel updates the report, adding a row label for each distinct value in the selected field. If you want the field to nest under an existing row field, drag it below that field in the Rows box. For example, placing Product below Region produces regions as the outer groups and products within each region.

You can also select the checkbox next to a field name, but Excel chooses an area for the field automatically. Text fields commonly go to Rows, while numeric fields commonly go to Values. Dragging a field directly into Rows is more reliable when you want to control its placement.

Choose and arrange row fields

A row field defines how the PivotTable groups its records. For a sales report, Region and Product might be row fields, while Sales is a value field that Excel sums. You can add more than one row field to create a hierarchy. The order matters: the field higher in the Rows box becomes the outer grouping, and fields beneath it become increasingly detailed groups.

For example, a report with Region above Product might show West, followed by the products sold in the West, then East and its products. Move Product above Region if you instead want each product listed first, with regions nested underneath. Drag fields up or down in the Rows area to change the hierarchy; Excel rearranges the report without changing the source records.

Other useful adjustments include:

Remove a row field: Drag it out of the Rows area, or clear its checkbox. This removes that grouping from the report, not the data from the source.
Change the field’s position: Drag it to a different place in Rows, Columns, Filters, or Values, depending on the report you want.
Expand or collapse groups: Use the expand/collapse controls beside labels when you want to see more or less detail in a nested report.
Filter row items: Use the drop-down beside a row label to show selected items. Filtering hides items in the report; it does not delete their source records.

Think about the question the report should answer before adding several fields. A long hierarchy can make a PivotTable harder to scan, while moving a field to Columns may make comparisons easier to read across the page.

Add a new record to the PivotTable

Adding a row to the source data is different from adding a row field. A PivotTable generally does not update just because you typed a new record into the worksheet: it must be refreshed, and its source must include the new record.

If the source is an Excel Table, add the record in the first row immediately below the table or in the row directly beside it, following the table’s existing columns. Excel Tables typically expand when data is entered directly next to them, making them a convenient source for PivotTables that change over time. Check that the new record has values under the same column headings as the existing records.

If the source is a normal cell range, make sure the range includes the new row. To check or change it, click the PivotTable and select PivotTable Analyze > Change Data Source. Select the complete source range, including its header row, and confirm. Then select PivotTable Analyze > Refresh, or right-click inside the PivotTable and choose Refresh.

A quick example: suppose a source range contains sales for January through March, and you add April records immediately below it. If the range stops at March, refreshing alone will not include April. Expand the source range or convert the source to an Excel Table, then refresh. If April is already inside the PivotTable’s source, a refresh should bring its records into the summary.

Refresh and check the results

Refreshing tells Excel to recalculate the PivotTable from its source. It does not necessarily change the source range. This distinction explains a common surprise: the Refresh command can run successfully while a newly appended record remains absent because the PivotTable’s source still ends above it.

After refreshing, check the report for the expected row label and value. If you do not see the new item, check that the source range includes the record, that its column headings match the existing headers, and that the relevant field is not filtered to hide the item. Also look for blank cells, extra spaces, or inconsistent spelling in the source: values such as “North” and “North ” can be treated as different labels.

To refresh multiple PivotTables and other workbook connections together, use Data > Refresh All. For just one report, PivotTable Analyze > Refresh is more targeted. Refreshing may update calculated summaries and item lists, so review any filters or sorting afterward if the report’s appearance matters.

Insert blank lines between row groups

If by “insert a row” you mean adding visual space between groups, use the PivotTable layout control rather than typing into a cell. Click inside the PivotTable and select Design > Blank Rows > Insert Blank Line After Each Item. The option applies blank lines after items in the relevant row-field layout, which can make a long report easier to read or print.

To remove those spaces, return to Design > Blank Rows and choose the option to remove blank lines. Blank lines are part of the PivotTable’s presentation, not new source records; they do not create additional categories or change the values being summarized. If the Blank Rows control is unavailable or does not produce the layout you expect, check that the PivotTable is selected and consider whether its current report layout supports the arrangement you want.

Why Excel may not let you type into a PivotTable row

PivotTable cells are generated from the source and the report’s field settings. Inserting or typing a cell inside the report can disrupt its structure, so Excel may prevent the edit or warn that it would affect a PivotTable. The dependable approach is to change the fields, source records, filters, or layout settings that create the report, then refresh when needed.

If you need a note or a manually entered value beside the report, place it outside the PivotTable’s changing area. A separate worksheet column or a separate note section is less likely to be overwritten or displaced when the PivotTable expands or refreshes. Avoid placing important notes immediately beside a report that may grow, because newly displayed rows or columns can occupy that space.

You can insert a normal worksheet row above or below a PivotTable when Excel allows it, but that does not insert a category into the report. Leave enough room for the PivotTable to expand, especially if new source items may appear. If Excel reports that it cannot complete an operation because it would affect another PivotTable, check for another report occupying the destination area.

Excel for Mac and Excel for the web

The field-list concept is the same in Excel for Mac: select the PivotTable, open its contextual PivotTable tab, show the field list, and place the desired field in Rows. Ribbon names and their exact placement can differ by Excel release and window size, so look for the PivotTable field-list control if it is not in the same location as on Windows. The Windows ribbon paths above describe Microsoft 365 for Windows.

Excel for the web also supports working with PivotTables, though available commands can differ from the desktop app. If you cannot find a source-range or layout command in the web ribbon, open the workbook in the desktop version of Excel and use the applicable PivotTable Analyze or Design command. In either version, distinguish changing the report’s fields from changing its source records.

Frequently Asked Questions

How do I add a row label to a PivotTable?

Click the PivotTable, open PivotTable Analyze > Field List, and drag the desired field into the Rows area. Excel creates row labels from that field’s distinct values.

How do I add a new row of data to a PivotTable?

Add the record to the PivotTable’s source data, confirm the source includes it, and refresh the report. If the source is a fixed range that ends before the new record, update the source range first.

Can I insert a blank row inside a PivotTable?

You generally cannot type an ordinary blank worksheet row into the middle of a PivotTable’s generated results. To add spacing between groups, use Design > Blank Rows > Insert Blank Line After Each Item.

Why is my new row missing after I refresh?

The source range may not include the new record, or a filter may hide its label. Check the source boundaries and column headers, then refresh again. Also check for inconsistent text values that may create a separate label.

How do I put a second field under a row field?

In the PivotTable Fields pane, drag the second field into the Rows area beneath the first field. The first field remains the outer group, and the second field supplies detail within each group.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.