OutliningAndGrouping

OutliningAndGrouping - Excel Outlining and Grouping...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: b46b377b81ee782423ab14224c85deeb170f7380.xls 12/20/2011 Excel Outlining and Grouping Overview Create a view of your worksheet that allows you to show or hide detail data. Detail When data is in list form, Microsoft Excel can create an outline to let you hide or show levels of detail with a single mouse click. An outline lets you quickly display only the rows or columns that provide summaries or groupings for sections of your worksheet, or display detail data associated with a summary row or column. How to Outline Data Automatic methods Data, Group and Outline, Auto Outline Data, Subtotals Manual method Data, Group and Outline, Group Sample Worksheets in this Workbook Data w/no existing summary formulas, but in a format suitable for automatic outlining. Data with summary formulas, auto outlined. Retail trade data but in list format, with no summary formulas. Subtotalling provides outline. Hierarchical text data, suitable for outlining. 8-Views and 9-View Worksheet A short description of how to create a worksheet view. Miscellaneous See Excel's online help for complete information about outlining and grouping. Choose Data, Group and Outline, Settings to select a look. 1-Companions and 2-Cpns Outlined Automatically 3-Retail Trade and 4-Retail Trade Auto Outlined 5-Retail Trade as List and 6-Rtl Trade Subtotalled 7-Agenda and 8-Outlined Agenda To display or hide outline symbols, use the Tools, Options, View dialog. Companion Animals: Suitable for Automatic Outlining Based on No. 424. Household Pet Ownership* Number of households aquiring companion animals by year (millions) Animal Year Number Bird 1993 5 Bird 1994 5.7 Bird 1995 5.7 Bird 1996 4.9 Bird 1997 3.2 Bird 1998 4.1 Bird 1999 2.2 Cat 1993 28.4 Cat 1994 42.6 Cat 1995 48.2 Cat 1996 31.2 Cat 1997 50.5 Cat 1998 29.9 Cat 1999 33.5 Dog 1993 42.5 Dog 1994 38.2 Dog 1995 36.5 Dog 1996 39.4 Dog 1997 42.3 Dog 1998 45.1 Dog 1999 40.3 Horse 1993 2.8 Horse 1994 2.8 Horse 1995 2 Horse 1996 2.2 Horse 1997 2.5 Horse 1998 2.8 Horse 1999 3.1 *Based on data at: http://www.avma.org The data in Excel list format. Companion Animals: Outlined Automatically Number of households aquiring companion animals by year (millions) Animal Year Number Bird 1993 5 Bird 1994 5.7 Bird 1995 5.7 Bird 1996 4.9 Bird 1997 3.2 Bird 1998 4.1 Bird 1999 2.2 Bird Total 30.8 Cat 1993 28.4 Cat 1994 42.6 Cat 1995 48.2 Cat 1996 31.2 Cat 1997 50.5 Cat 1998 29.9 Cat 1999 33.5 Cat Total 264.3 Dog 1993 42.5 Dog 1994 38.2 Dog 1995 36.5 Dog 1996 39.4 Dog 1997 42.3 Dog 1998 45.1 Dog 1999 40.3 Dog Total 284.3 Horse 1993 2.8 Horse 1994 2.8 Horse 1995 2 Horse 1996 2.2 Horse 1997 2.5 Horse 1998 2.8 Horse 1999 3.1 Horse Total 18.2 Grand Total 597.6 Retail Trade Data: Requires Manual Outlining No. 1275. Retail Trade--Sales, by Kind of Business* [In billions of dollars (375.2 represents $375,200,000,000). Sales and inventories for leased departments and concessions are tabulated in the kind-of-business category of the leased department or concession....
View Full Document

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 11

OutliningAndGrouping - Excel Outlining and Grouping...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online