Download ArticleDownload ArticleThis article was written by Stan Kats and by How.com.vn staff writer, Nicole Levine, MFA. Stan Kats is a Professional Technologist and the COO and Chief Technologist for The STG IT Consulting Group in West Hollywood, California. Stan provides comprehensive technology solutions to businesses through managed IT services, and for individuals through his consumer service business, Stan's Tech Garage. Stan holds a BA in International Relations from The University of Southern California. He began his career working in the Fortune 500 IT world. Stan founded his companies to offer an enterprise-level of expertise for small businesses and individuals.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 238,703 times.
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.
Steps
Review your source data. 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.
Click any cell in the PivotTable. 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
Reorder the field labels in the "Row Labels" section. 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.
Review your source data. 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.
Click anywhere in your pivot table. This opens the pivot table editor on the right side of Google Sheets.
Click Add under "Rows." It's in the left side of the pivot table editor. A list of fields will expand on the menu.[7]
Click the name of the field you want to add as a row. 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.
Rearrange your rows as needed. 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]
Video
Expert Q&A
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
References
- ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
- ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
- ↑ https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2
- ↑ https://support.microsoft.com/en-gb/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576
- ↑ https://support.microsoft.com/en-us/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-80160adfebec
- ↑ https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80
- ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop
- ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop
- ↑ https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop
About This Article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
