Learn how to create nested subtotals

Here are the steps to follow in this video lesson:

  1. Sort your data before creating your 1st Subtotal (Data, Subtotals, etc.)
  2. Create your 2nd (“nested”) Subtotal – remember to choose a different field for “At each change in:”
  3. Uncheck the “Replace current subtotals” box.
  4. Before you can “copy and paste” your 2nd level subtotal outlined view click – Edit, Go to, Special, Visible cells only” – or use the Keyboard Shortcut Alr+;

Find the Excel Video Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Awesome tips, thanks!

Speak Your Mind