Contextures

Contextures News 20150217

Hide Subtotals + more Excel tips

February 17, 2015

In this week's Excel news, you'll see how to quickly hide pivot table subtotals, and much more, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Hide Pivot Table Subtotals

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

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • In a short video, Bill Jelen (Mr. Excel) and Mike Girvin (ExcelIsFun) show two different ways to insert an apostrophe at the start of each number in long column of numbers. Starting at the 1:00 mark, Bill shows how an apostrophe, and other characters, affected cell entries in old versions of Lotus 1-2-3.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

  • Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.

Video: Connect Slicers to Multiple Pivot Tables

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

Way Back When

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!

weekly photo

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
[email protected] contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Last updated: February 17, 2020 4:15 PM