It is also possible to group this worksheet data so that you can hide columns B and C in addition to the grouped rows. So, with the outline already in place, manually add the grouping to columns B and C by selecting these columns and group them by choosing Data tab > Group > Group.
» Outlines and Views
Now let's change the outlining display to your version #2. Look for the worksheet data by expanding or compressing the grouped items.
Save this layout as a second view with a different name. Then, when youre done you can then select the Custom Views button, click a View by name and click Show to display it.
The worksheet will change to show the outline as it was when you created the view. You can switch between views from the Custom Views menu with two clicks instead of having to reset the outline manually each time.
So, next time you need to summarize the data in your worksheet and reduce it to more manageable levels the outline tool can help you group Excel data in an intelligent way.
Helen Bradley is a respected international journalist writing regularly for small business and computer publications in the USA, Canada, South Africa, UK and Australia. You can learn more about her at her Web site, HelenBradley.com
Adapted from winplanet.com.
|Do you have a comment or question about this article or other small business topics in general? Speak out in the SmallBusinessComputing.com Forums. Join the discussion today!|