How To Add Rows To A Pivot Table 9 Steps With Pictures

For example, if you want to add a row for a specific purchase, make sure that purchase is listed in the appropriate column in your source data.

If you have already moved the appropriate field to the Rows area but don’t see a row that’s in your source data, just press Alt + F5 or right-click the pivot table and select Refresh.

Rows are usually non-numeric fields, such as column headers. Numbers will usually go into the Values area. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

For example, if you want to add a row for a specific purchase, make sure that purchase is listed in the appropriate column in your source data.

You can also drag any of the labeled fields from the right side of the pivot table panel directly to the Rows area.