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

• Produce subtotals for your data