Microsoft 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 training 
 Home Programs Meet Dawn Free E-zine Contact What's New Site Map 
Excel: Subtotals  

Services
Tips & Tricks
The Pro Shop
How-To Lessons
Free Articles
Newsletter
Resources

 
Dawn Bjork Buzbee
The Software Pro®

Microsoft Certified Application Specialist (MCAS) Instructor

Certified Microsoft Office Specialist Master 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
 


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.
Tips, Tricks, Secrets that you need to know now!

Discover the secrets that you wish you knew before...all of this plus 15 BONUS SHORTCUTS when you sign-up for the Smart & Easy Software Tips & Tricks Newsletter!
Start Being More Productive Today!
CLICK HERE to sign-up directly via e-mail.
Home for Dawn Bjork Buzbee, The Software Pro Contact Dawn Bjork Buzbee, The Software Pro
 
www.SoftwarePro.com
Home | Services | Tips & Tricks | The Pro Shop | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

Copyright 1995-2008 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 Application Specialist (MCAS) Instructor (Office 2007 & Windows Vista)
Certified Microsoft Office Specialist Master Instructor § Certified Microsoft Office Expert § Certified Women's Business Enterprise (WBE)
The Software Pro® is a registered trademark