How to Add Rows to a Pivot Table

PDF download Download Article
PDF download Download Article

You can use pivot tables in Excel and Google Sheets to group and organize data in a spreadsheet . Adding rows to a pivot table is as simple as dragging fields into the "Rows" area of your pivot table formatting panel. We'll show you how to add new rows to an existing pivot table in both Microsoft Excel and Google Sheets.

Method 1
Method 1 of 2:

Microsoft Excel

PDF download Download Article
  1. Click the tab that contains the data you're using in your pivot table, and make sure it contains the data you want to use to create your new row. [1]
    • 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.
  2. This opens the PivotTable Fields panel on the right side of Excel. [2]
    • 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 . [3]
    Advertisement
  3. When you drag any of the fields in the upper portion of the PivotTable Fields panel to Rows, a new row will be added to your table. [4]
    • Rows are usually non-numeric fields, such as column headers. Numbers will usually go into the Values area. [5]
  4. If you already have a field in the Rows area, adding another row below that will nest the new row within the existing row. [6] You can drag the rows up or down to change which row is nested within the other.
    5. Advertisement
Method 2
Method 2 of 2:

Google Sheets

PDF download Download Article
  1. Click the tab that contains the data you're using in your pivot table, and make sure it contains the data you want to use to create your new row.
    • 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.
  2. This opens the pivot table editor on the right side of Google Sheets.
  3. It's in the left side of the pivot table editor. A list of fields will expand on the menu. [7]
  4. Rows are usually non-numeric fields, such as category names and/or column headers. Once you select a field, a new row or rows will be added for the items in that field. [8]
    • You can also drag any of the labeled fields from the right side of the pivot table panel directly to the Rows area.
  5. If you have multiple rows, adding a new row under an existing row will nest the new row within the existing row. You can drag the row field names up or down to change the order if you want to change the nesting order. [9]
    6. Advertisement

Video

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      • If you want to add a custom row that isn't coming from a particular data source, the best thing to do would be to copy the data from the pivot table and paste it into a new worksheet. You can then edit that worksheet as you would any other worksheet, although the values will no longer calculate automatically.
        Thanks
        Helpful 1 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Add Data to a Pivot Table
      How to
      Add Custom Calculated Fields to Pivot Tables in Excel
      How to
      Create a Chart from a Pivot Table
      Add Header Row in Excel: Freezing, Printing, Tables, Power Query
      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to
      Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
      The 3 Easiest Ways to Sort by Number in Google Sheets
      3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to
      Change the X Axis Scale in an Excel Chart
      How to
      Make a Google Spreadsheet: Beginners Guide
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
      2. ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
      3. ↑ https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2
      4. ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
      5. ↑ https://support.microsoft.com/en-us/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-80160adfebec
      6. ↑ https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80
      7. ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop
      8. ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop
      9. ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop

      About This Article

      Article Summary X

      1. Make sure the info for the row is in your source data.
      2. Click the pivot table.
      3. Drag a field to the "Rows" area.
      4. Reorder rows as needed.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 256,898 times.

      Is this article up to date?

      Advertisement