Hide Subtotals + more Excel tips
Excel Weekly News from Contextures February 17, 2015
In this week's Excel news, you'll see how to quickly hide pivot table subtotals, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
If you add more than one field to a pivot table's Row Labels area, you'll probably see subtotals on some of those fields. If you don't need them, you can quickly hide the subtotals, by using a command on the Excel Ribbon. Or, if you need to hide subtotals in several pivot tables, you can use a macro to do the job for you.
See the details in my blog post, and watch the short video: Hide Pivot Table Subtotals
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
Slicers are a great way to filter a pivot table, and in this video you can see how to filter more than one pivot table, with a single slicer. This is a great way to show results on a dashboard, using GETPIVOTDATA to pull numbers from filtered pivot tables.
Click here to watch the short video that show how it works: Connect Slicers to Multiple Pivot Tables
It was my mother's birthday last week, so I looked for an old picture of us together, to share with her. It looks like we're on a picnic outing in this photo, but in fancier clothes than we would wear for today's picnics. And yes, my cheeks are a little thinner now!
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.