课程: 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.
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程
内容
-
-
LEFT and FIND with Excel53 秒
-
Sum across multiple sheets with Excel21 秒
-
Scan data from a paper document on mobile with Excel22 秒
-
Remove PivotTable subtotals with Excel24 秒
-
Rearrange PivotTable fields with Excel32 秒
-
Create a custom number format with Excel47 秒
-
COUNTIF wild card trick with Excel54 秒
-
Assign into buckets with XLOOPUP with Excel57 秒
-
Absolute referencing with Excel1 分钟 26 秒
-