Table of Contents
The process of removing the Grand Total from a Pivot Table in Excel involves accessing the Pivot Table Options and unchecking the “Show grand totals for columns/rows” box. This will remove the Grand Total from the table, allowing for a more specific and focused view of the data. By following this step, users can easily customize their Pivot Tables and present their data in a more concise and organized manner.
Excel: Remove Grand Total from Pivot Table
Often you may want to remove the grand total row from a pivot table in Excel.
Fortunately this is easy to do by using the Grand Totals button within the Design tab.
The following example shows exactly how to do so.
Example: Remove Grand Total from Excel Pivot Table
Suppose we have the following dataset in Excel that shows the points scored by basketball players on various teams:
Now suppose we insert the following pivot table to summarize the sum of points by team:
By default, Excel creates a Grand Total row that shows the grand total of the points values.
To remove this Grand Total row, first click on any cell in the pivot table.
Then, click the Design tab along the top ribbon and then click the dropdown button titled Grand Totals, then click Off for Rows and Columns:
The Grand Total row will be removed from the pivot table:
Note that within the Grand Totals dropdown menu, you can also choose to display the grand total only for the rows or columns if you’d like.
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How can I remove the Grand Total from a Pivot Table in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-remove-the-grand-total-from-a-pivot-table-in-excel/
stats writer. "How can I remove the Grand Total from a Pivot Table in Excel?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-remove-the-grand-total-from-a-pivot-table-in-excel/.
stats writer. "How can I remove the Grand Total from a Pivot Table in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-remove-the-grand-total-from-a-pivot-table-in-excel/.
stats writer (2024) 'How can I remove the Grand Total from a Pivot Table in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-remove-the-grand-total-from-a-pivot-table-in-excel/.
[1] stats writer, "How can I remove the Grand Total from a Pivot Table in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I remove the Grand Total from a Pivot Table in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.