Format your Subtotal title lines

Here are the stepes to follow for this video lesson:

  1. Create your subtotals – remember to SORT your data first!
  2. Choose Subtotal Outline 2 – in most cases this shows the Subtotal Title Lines only.
  3. Select the data that you wish to format.
  4. Click Edit, Go to, Special, Visible Cells Only (Or the keyboard shortcut Alt+;) and apply your formatting.

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

rss Subscribe to our RSS Feed

This entry was posted on Sunday, August 3rd, 2008 at 7:38 AM and is filed under Excel Data Tables and Lists, Excel Training, Tips and Time Savers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

One Response to “Format your Subtotal title lines”

  1. The Company Rocks Excels » Blog Archive » Produce Subtotals for your data Says:
    March 14th, 2009 at 6:23 AM

    [...] Format your subtotal title lines Share and Enjoy: [...]

Leave a Reply

Powered by WishList Member - Membership Site Software