Excel Faster Way to Suppress Subtotals in an Excel Pivot Table - Episode 824
2,470 views · Published 12 January 2009 · 2:24 · Indexed 18 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Faster Way to Suppress Subtotals in an Excel Pivot Table. Welcome back to the MrExcel netcast! In this video, I'll be sharing a helpful tip for those of us who frequently work with pivot tables. But before we dive into that, I want to invite you to check out our upcoming seminars. We have a bunch of them scheduled for September, starting with the SouthEast Accounting Show in Atlanta on August 27th. Then, we'll be touring Alabama in September, with stops in Montgomery, Birmingham, and Orange Beach. We also have seminars in Springfield, Missouri and a three-day bootcamp with Mike Alexander and myself, which we're moving to the east coast this year. If you're interested, head over to MrExcel and click on the upcoming seminars tab for more information. Now, let's get into the tip. During a recent seminar, I learned a cool trick from one of the attendees, Brian. He showed me a faster way to get rid of subtotals in a pivot table. Normally, I would double-click on the field and change it from automatic to none, but this requires multiple clicks for each subtotal. Brian's method, on the other hand, only requires one command. Simply select all the rows with the subtotals you want to remove, right-click, and choose "hide". This does the same thing as manually changing each subtotal to none, but in a fraction of the time. A great time-saver for those of us who work with pivot tables frequently. I always love learning new tips and tricks from my seminar attendees, and I'm sure there are many more out there. If you have any helpful Excel tips, please share them in the comments below. And don't forget to subscribe to our channel for more Excel tutorials and netcasts. Thanks for watching, and I'll see you next time on the MrExcel netcast! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Brian from Bentonville provides the idea for this podcast. Episode 824 shows you much faster way to remove subtotals from all of the outer row fields in a pivot table. Table of Contents: (00:00) Introduction to upcoming seminars (00:23) September seminar schedule (00:34) Three-day bootcamp announcement (00:44) Location change for bootcamp (00:54) Learning from Excel gurus (01:05) Tip from Brian on pivot tables (01:57) Time-saving pivot table command (02:07) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: East coast seminar in Alexandria, Virginia Excel tips and tricks Hiding subtotals in pivot tables MrExcel netcast episodes Removing pivot table subtotals SouthEast Accounting Show Springfield, Missouri seminars Three-day bootcamp with Mike Alexander Time-saving techniques for pivot tables Tour of Alabama Upcoming seminars Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152058/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919