FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 23, 2016

Hi fellow Excel Addict,

Greetings from cold, windy, sunny, and slightly snow-covered Newfoundland.

Francis Hayes (

It's Tuesday again and time for another 'Excel in Seconds' tip to help you get your work done faster and smarter.

If you missed Thursday's 'Excel in Minutes' tip where I showed you how to 'Prevent Duplicate Values in a Column', you can 
find it here.

Free Webinars: Just a quick reminder that there are only a couple of days left (till Thursday) to access Mynda's free online Excel Dashboard Webinars. I've seen these webinars and they are awesome! Find out more here or and sign up for a time that suits your schedule.

If you have a favourite tip, or a problem that you've been trying to solve, that I
could possible share in my newsletter, please send it along to me.

I hope you enjoy the rest of your week.

Take care and keep Excelling,

Francis Hayes (The Excel Addict)

Francis Hayes ( Quote of the Day

"After the final No there comes a Yes"
-- Wallace Stevens --

If you missed my last newsletter, you can click here to view it online.

Take you Excel reporting to a whole new level
Learn Excel Dashboard Reporting
Free Excel Dashboard Webinar
See Excel Dashboards in action and learn how to create an interactive Excel Dashboard...for FREE?

Mynda's Excel Dashboard Reporting Course

Excel in Seconds with

Drill Down to See the Details for Any Pivot Table Subtotal

Pivot Tables are great for summarizing lots of data. But when you're looking at the subtotals or grand totals in a Pivot Table, you often need to know what makes up that amount. There is a 'so-simple-but-not-so-obvious' trick that you can use to quickly drill down and see those details.

Simply double-click on any subtotal or total in a Pivot Table to get the details of that amount.

For example, in the Pivot Table below, a breakdown of the Jan-2016, Computer Paper sales can be found by double clicking on its subtotal. A new worksheet will be inserted into your workbook containing the detailed source data that was used to calculate that subtotal.

Double Click To Drill Down Pivot Table Totals_in_Microsoft_Excel_2007_2010_2013_2016_365
A word of caution about working with these detail sheets: When you have finished working with your detailed sheet, be careful not to close it without saving changes. Remember that is is part of the workbook containing the Pivot Table, so you could inadvertently lose some of your unsaved changes. I have done this more times that I am willing to admit.

Learn Excel Dashboards

Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630