From the course: Nano Tips for Using Excel with Kat Norton
Remove PivotTable subtotals with Excel
From the course: Nano Tips for Using Excel with Kat Norton
Remove PivotTable subtotals with Excel
“
- Have you ever wanted to remove that grand total section at the bottom of a PivotTable? Maybe you don't need that data point, or you don't love the look of it. Here is how we can do it. Right-click on the table, and then, select PivotTable Options, and in that menu, we're going to want to click the Totals & Filters tab, and uncheck those grand total boxes, and now, when we click OK, our table's looking fresh.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
LEFT and FIND with Excel53s
-
Sum across multiple sheets with Excel21s
-
Scan data from a paper document on mobile with Excel22s
-
Remove PivotTable subtotals with Excel24s
-
Rearrange PivotTable fields with Excel32s
-
Create a custom number format with Excel47s
-
COUNTIF wild card trick with Excel54s
-
Assign into buckets with XLOOPUP with Excel57s
-
Absolute referencing with Excel1m 26s
-