Here are the stepes to follow for this video lesson:
- Create your subtotals – remember to SORT your data first!
- Choose Subtotal Outline 2 – in most cases this shows the Subtotal Title Lines only.
- Select the data that you wish to format.
- 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
Link to this post!
[…] Format your subtotal title lines Share and Enjoy: […]