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 E-zine Media Room Contact 
Excel: Subtotals  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus 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)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@TheSoftwarePro.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
 



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.TheSoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

Copyright 2015 The Software Pro & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
Dawn@TheSoftwarePro.com www.TheSoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2013 Specialist (MOS 2013) Master
Certified Microsoft Office 2010 Specialist (MOS 2010) 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) WBENC Certified
WOSB (Women-Owned Small Business) Certified
The Software Pro
is a registered trademark
Terms & Conditions       Privacy Policy