Microsoft Office 2010 Expert, Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training 
 Home Products Programs Meet Dawn Free Newsletter Media Room Contact 
Excel: Subtotals  

Training
Speaking
Consulting
Tips & Tricks
The Pro Shop
How-To Lessons
Free Articles
Newsletter
Resources

 
Dawn Bjork Buzbee
The Software Pro®

Microsoft Certified Trainer (MCT)

Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor

Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Expert

Certified Women's Business Enterprise (WBE)

(303) 699-6868
Dawn@SoftwarePro.com

Microsoft Excel: Multilevel Subtotals

For Microsoft Office Excel 2003 & 2002

Problem: Subtotals on Wrong Rows

When you create multilevel subtotals for data in Microsoft Excel 2002 or Microsoft Office Excel 2003, and you set the subtotals to appear in the rows that are immediately above the data that they are based on, the totals appear in the incorrect order (staggered incorrectly) and may exclude extra Grand Totals values. This is a known problem with some installations of Excel. Learn more about the fix at the Microsoft support website:

Microsoft Support: Fix Excel Subtotals

IMPORTANT: This fix may include a change to the Windows Registry. This option, however, should only be explored by experienced support personnel.

Go To Top of Page
 


Tips, Tricks, Secrets that you need to know now!
Discover the secrets you wish you knew before...all of this plus 15 BONUS SHORTCUTS and access to handouts with 350+ MORE SHORTCUTS AND TIPS when you sign-up for the Smart & Easy Software Tips & Tricks eMagazine!

Start Being More Productive Today!
CLICK HERE to sign-up directly via email.
Home for Dawn Bjork Buzbee, The Software Pro
 Contact Dawn Bjork Buzbee, The Software Pro
Hot Tip
Create Excel subtotals at Data > Subtotals.
 
Did You Know?
To add more than one level of subtotals, uncheck the option Replace current subtotals.

 
www.SoftwarePro.com
Home | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 1995-2011 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868 § Dawn@SoftwarePro.com § 11675 Bent Oaks Street, Suite 200; Parker, Colorado 80138 USA § www.SoftwarePro.com
Geek Speak Becomes People Friendly™
Microsoft Certified Trainer (MCT) § Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor § Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor § Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro® is a registered trademark
 Terms & Conditions       Privacy Policy