Outlining And Grouping
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Outlining And Grouping as PDF for free.
More details
- Words: 5,346
- Pages: 12
9152032.xls
10/17/2008
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 1-Companions and 2-Cpns Outlined Automatically Data w/no existing summary formulas, but in a format suitable for automatic outlining. 3-Retail Trade and 4-Retail Trade Auto Outlined Data with summary formulas, auto outlined. 5-Retail Trade as List and 6-Rtl Trade Subtotalled Retail trade data but in list format, with no summary formulas. Subtotalling provides outline. 7-Agenda and 8-Outlined Agenda 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.
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) The data in Excel list format.
Animal Bird Bird Bird Bird Bird Bird Bird Cat Cat Cat Cat Cat Cat Cat Dog Dog Dog Dog Dog Dog Dog Horse Horse Horse Horse Horse Horse Horse
Year 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999
*Based on data at: http://www.avma.org
Number 5 5.7 5.7 4.9 3.2 4.1 2.2 28.4 42.6 48.2 31.2 50.5 29.9 33.5 42.5 38.2 36.5 39.4 42.3 45.1 40.3 2.8 2.8 2 2.2 2.5 2.8 3.1
Companion Animals: Outlined Automatically Number of households aquiring companion animals by year (millions) Animal Bird Bird Bird Bird Bird Bird Bird Bird Total Cat Cat Cat Cat Cat Cat Cat Cat Total Dog Dog Dog Dog Dog Dog Dog Dog Total Horse Horse Horse Horse Horse Horse Horse Horse Total Grand Total
Year 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999
Number 5 5.7 5.7 4.9 3.2 4.1 2.2 30.8 28.4 42.6 48.2 31.2 50.5 29.9 33.5 264.3 42.5 38.2 36.5 39.4 42.3 45.1 40.3 284.3 2.8 2.8 2 2.2 2.5 2.8 3.1 18.2 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. Based on Current Business Survey, see Appendix III and summary below.]
Business Durable Goods Durable goods stores, total \2 Building materials and garden supplies \2 Building materials, supply stores Hardware stores Durable Goods Totals Automotive Automotive dealers Motor vehicle, misc. automotive dealers Motor vehicle dealers New and used car dealers Auto and home supply stores Automotive Totals Household Furniture and homefurnishings stores \2 Furniture, homefurnishings stores \2 Furniture stores Floor covering stores Appliance, radio, TV, & computer stores Household appliance stores Radio, TV, and computer stores Household Totals Leisure Sporting goods and bicycle shops Book stores Jewelry stores Leisure Totals Nondurable Goods Nondurable goods stores, total \2 General merchandise stores Department stores \3 Variety stores Misc. general merchandise stores Nondurable Goods Totals Food Food stores Grocery stores Gasoline service stations Food Totals Apparel Apparel and accessory stores \2 Men's and boys' clothing stores Women's clothing specialty stores Women's clothing stores Family clothing stores Shoe stores Apparel Totals Food Eating and drinking places Eating places \2 Restaurants, lunchrooms, cafeterias Refreshment places Drinking places Food Service Totals Specialty Drug stores and proprietary stores Liquor stores Nonstore retailers Catalog and mail-order houses Fuel dealers Specialty Sales Totals Grand Totals
1970
1980
1981
1982
1983
575.9 83.5 61.3 11.0 731.7
1988 629.2 91.1 66.8 11.9 799.0
1989 657.2 92.4 67.5 12.6 829.7
1990 668.8 94.6 70.3 12.5 846.2
1991 650 91.5 68.2 12.1 821.8
1992 703.6 100.8 75.4 12.7 892.5
1993
1994
336.2 51.0 35.1 8.7 431.0
65.2 59.2 57.2 54.3 6.0 241.9
164.1 146.2 137.7 130.5 18.0 596.5
181.9 162.3 153.0 144.5 19.6 661.3
192.4 172.4 162.9 154.7 20.1 702.5
17.0 10.4 (NA) (NA) 5.6 (NA) (NA) 33.0
44.2 26.3 (NA) (NA) 14.0 (NA) (NA) 84.5
46.9 27.5 (NA) (NA) 15.4 (NA) (NA) 89.8
46.8 27.1 (NA) (NA) 15.8 (NA) (NA) 89.7
54.7 31.3 19.79 (NA) 19.3 6.73 12.55 144.3
61.4 35.6 22.3 7.6 21.5 7.4 14.1 169.9
68.3 38.3 23.9 7.9 25.1 8.4 16.7 188.6
75.7 43.0 26.0 8.7 27.0 9.3 17.8 207.5
78.1 44.5 26.7 9.9 27.1 8.6 18.5 213.4
85.4 47.6 28.2 11.1 30.6 8.7 21.9 233.5
91.3 51.2 31.9 10.7 32.7 9.3 23.4 250.5
91.5 50.5 30.8 10.7 33 8.8 24.3 249.6
91.7 49.5 30.2 10.1 33.6 8.3 25.3 248.7
96.9 52.3 31.2 10.4 35.8 8.4 27.4 262.4
105.5 54.8 32.8 10.8 41.3 9.1 32.2 286.5
119.1 59.2 34.8 11.7 49.5 9.0 40.5 323.8
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) 9.6 9.6
8.3 4.1 10.8 23.2
8.7 4.5 11.2 24.4
9.2 4.8 12.2 26.2
11.3 5.3 12.9 29.5
12.8 6 14.3 33.1
14.2 6.5 14.4 35.1
15 7.4 15.2 37.6
15.1 7.7 14.8 37.6
15.6 8.3 15.3 39.2
16.8 9.1 16.7 42.6
18.9 10.1 18.1 47.1
260.3 49.1 (NA) 6.1 (NA) 315.5
658.1 109.0 85.5 7.8 15.7 876.1
713.9 120.4 (NA) 8.2 (NA) 842.5
733.2 779.3 832.4 876.9 908.9 965.4 1027 1101.8 1175.8 1206 1,248.0 1,300.2 1,361.5 124.6 136.0 150.3 158.6 169.4 182.0 192.5 206.3 215.5 226.7 246.4 264.0 282.1 (NA) 108.64 120.5 126.4 134.5 144.0 151.5 160.5 165.8 172.9 186.4 199.9 217.5 8.2 8.4 8.7 8.5 7.4 7.1 7.5 7.9 8.3 8.3 9.5 9.7 9.5 (NA) 18.95 21.1 23.8 27.5 30.8 33.5 37.8 41.4 45.5 50.5 54.4 55.1 866.0 1051.2 1133.0 1194.2 1247.7 1329.3 1412.0 1514.3 1606.8 1659.4 1740.8 1828.2 1925.7
90.0 82.6 28.9 201.5
220.2 205.6 94.1 519.9
236.2 220.6 103.1 559.9
246.1 230.7 97.4 574.2
256.0 240.4 102.9 599.3
271.9 256.5 107.6 636.0
285.1 269.5 113.3 667.9
297.0 280.8 102.1 679.9
309.5 291.0 104.8 705.3
325.5 307.2 110.3 743.0
347 328.1 122.9 798.0
368.3 348.2 138.5 855.0
374.5 354.3 137.3 866.1
377.1 358.1 137.0 872.2
382.7 363.6 141.7 888.0
394.2 374.6 148.9 917.7
22.1 4.5 8.2 7.1 4.4 4.5 50.8
49.3 7.7 17.6 15.9 10.8 10.5 111.8
54.0 7.9 19.1 17.2 12.3 11.8 122.3
55.6 7.8 20.0 18.2 13.7 11.4 126.7
60.2 8.0 21.8 19.9 15.4 11.9 137.2
64.3 8.2 23.8 21.2 16.4 12.3 146.2
70.2 8.5 26.1 23.6 17.8 13.1 159.3
75.6 8.6 28.6 25.7 19.3 13.9 171.7
79.3 9.0 29.2 26.4 21.5 14.6 180.0
85.3 9.8 30.6 27.4 23.9 15.4 192.4
92.3 10.5 32.2 29 26.4 17.3 207.7
95.8 10.5 32.8 29.8 28.4 18 215.3
97.4 10.4 32.9 29.9 30.5 17.5 218.6
104.2 10.2 35.8 31.8 33.2 18.1 233.3
107.4 10.0 36.3 32.4 35.4 18.5 240.0
110.4 10.1 34.8 30.6 38.2 19.3 243.4
30.5 25.5 (NA) (NA) (NA) 56.0
90.1 80.4 (NA) (NA) (NA) 170.5
98.1 88.2 (NA) (NA) (NA) 186.3
104.6 95.1 (NA) (NA) (NA) 199.7
113.3 103.6 60.96 41.6 9.64 329.1
121.3 111.5 66.0 44.4 9.8 353.0
127.9 117.6 68.2 48.1 10.3 372.1
139.4 128.6 75.2 51.6 10.9 405.7
153.5 142.6 81.1 59.6 10.8 447.6
168 157.1 87.7 67 10.9 490.7
177.8 167.2 92.9 71.5 10.7 520.1
190.1 178.7 99.9 75.7 11.5 555.9
194.4 182.6 102.4 77.2 11.8 568.4
200.2 187.8 103.6 81.5 12.4 585.5
212.8 200.5 108.9 88.9 12.3 623.4
222.1 210.2 114.8 92.6 11.9 651.6
14.6 8.4 9.1 (NA) (NA) 32.1
31.0 16.9 22.8 (NA) (NA) 70.7
34.0 17.7 23.6 (NA) (NA) 75.3
36.4 18.1 23.8 (NA) (NA) 78.3
40.6 19.1 25.3 12.81 (NA) 97.8
44.0 18.3 27.8 15.0 16.8 121.9
47.0 19.5 28.3 15.8 16.8 127.4
50.5 19.9 30.3 17.2 14.1 132.0
54.1 19.8 35.9 20.8 14.5 145.1
57.8 19.6 40.5 23.9 14.8 156.6
63.3 20.1 43.6 26.2 14.7 167.9
70.6 21.7 45.6 26.6 15.6 180.1
75.5 22.5 49.1 30 14.6 191.7
77.8 21.7 55.2 35.5 14.2 204.4
79.7 21.6 60.6 40.5 15.0 217.4
82.0 22.1 68.7 46.3 15.9 235.0
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
*Note: From http://www.census.gov/econ/www/retmenu.html
540.7 77.1 56.5 10.7 685.0
1987
324.8 52.2 35.7 8.5 421.2
Source: U.S. Census Bureau, Current Business Reports, Annual Benchmark Report for Retail Trade, January 1990 Through December 1999, (BR/99-A) and prior issues.
498.1 71.2 50.8 10.5 630.6
1986
299.2 50.8 35.0 8.3 393.3
X Not applicable. NA Not available. \1 Based on 1987 Standard Industrial Classification code; see text, Section 13, Labor Force. \2 Includes kinds of business, not shown separately. \3 Excludes leased departments.
454.5 67.1 47.1 10.4 579.1
1985
114.8 18.1 11.3 3.0 147.2
Footnotes:
390.85 58.7 41.3 9.1 500.0
1984
781.9 886.7 110.7 125.2 83.1 94.6 13.1 13.8 988.8 1120.3
230.0 273.3 303.2 326.1 342.9 372.6 386 387.6 372.6 406.9 459.3 525.3 207.9 250.2 278.0 301.1 316.3 343.2 356.5 356.8 343 377.1 428.5 492.4 198.0 236.7 263.1 284.5 298.8 324.9 337.7 338.7 325.2 359.3 408.1 469.1 187.7 225.9 251.6 270.4 280.5 303.3 311.6 316 301.3 333.8 379.5 435.7 22.1 23.1 25.2 25.1 26.6 29.4 29.5 30.8 29.6 29.8 30.8 32.9 845.7 1009.2 1121.1 1207.2 1265.1 1373.4 1421.3 1429.9 1371.7 1506.9 1706.2 1955.4
Retail Trade Data: Requires Manual Outlining No. 1275. Retail Trade--Sales, by Kind of Business*
Note: Because the summary lines are formulas, this data can be outlined automatically. Select the data and choose Data, Group and Outline, Auto Outline. Excel creates 3 [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 levels concession. of detail. Based on Current Business Survey, see Appendix III and summary below.]
Business Durable Goods Durable goods stores, total \2 Building materials and garden supplies \2 Building materials, supply stores Hardware stores Durable Goods Totals Automotive Automotive dealers Motor vehicle, misc. automotive dealers Motor vehicle dealers New and used car dealers Auto and home supply stores Automotive Totals Household Furniture and homefurnishings stores \2 Furniture, homefurnishings stores \2 Furniture stores Floor covering stores Appliance, radio, TV, & computer stores Household appliance stores Radio, TV, and computer stores Household Totals Leisure Sporting goods and bicycle shops Book stores Jewelry stores Leisure Totals Nondurable Goods Nondurable goods stores, total \2 General merchandise stores Department stores \3 Variety stores Misc. general merchandise stores Nondurable Goods Totals Food Food stores Grocery stores Gasoline service stations Food Totals Apparel Apparel and accessory stores \2 Men's and boys' clothing stores Women's clothing specialty stores Women's clothing stores Family clothing stores Shoe stores Apparel Totals Food Eating and drinking places Eating places \2 Restaurants, lunchrooms, cafeterias Refreshment places Drinking places Food Service Totals Specialty Drug stores and proprietary stores Liquor stores Nonstore retailers Catalog and mail-order houses Fuel dealers Specialty Sales Totals Grand Totals
1970
1980
1981
1982
1983
575.9 83.5 61.3 11.0 731.7
1988
629.2 91.1 66.8 11.9 799.0
1989
657.2 92.4 67.5 12.6 829.7
1990
668.8 94.6 70.3 12.5 846.2
1991
650 91.5 68.2 12.1 821.8
1992
703.6 100.8 75.4 12.7 892.5
1993
1994
336.2 51.0 35.1 8.7 431.0
65.2 59.2 57.2 54.3 6.0 241.9
164.1 146.2 137.7 130.5 18.0 596.5
181.9 162.3 153.0 144.5 19.6 661.3
192.4 172.4 162.9 154.7 20.1 702.5
17.0 10.4 (NA) (NA) 5.6 (NA) (NA) 33.0
44.2 26.3 (NA) (NA) 14.0 (NA) (NA) 84.5
46.9 27.5 (NA) (NA) 15.4 (NA) (NA) 89.8
46.8 27.1 (NA) (NA) 15.8 (NA) (NA) 89.7
54.7 31.3 19.79 (NA) 19.3 6.73 12.55 144.3
61.4 35.6 22.3 7.6 21.5 7.4 14.1 169.9
68.3 38.3 23.9 7.9 25.1 8.4 16.7 188.6
75.7 43.0 26.0 8.7 27.0 9.3 17.8 207.5
78.1 44.5 26.7 9.9 27.1 8.6 18.5 213.4
85.4 47.6 28.2 11.1 30.6 8.7 21.9 233.5
91.3 51.2 31.9 10.7 32.7 9.3 23.4 250.5
91.5 50.5 30.8 10.7 33 8.8 24.3 249.6
91.7 49.5 30.2 10.1 33.6 8.3 25.3 248.7
96.9 52.3 31.2 10.4 35.8 8.4 27.4 262.4
105.5 54.8 32.8 10.8 41.3 9.1 32.2 286.5
119.1 59.2 34.8 11.7 49.5 9.0 40.5 323.8
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) 9.6 9.6
8.3 4.1 10.8 23.2
8.7 4.5 11.2 24.4
9.2 4.8 12.2 26.2
11.3 5.3 12.9 29.5
12.8 6 14.3 33.1
14.2 6.5 14.4 35.1
15 7.4 15.2 37.6
15.1 7.7 14.8 37.6
15.6 8.3 15.3 39.2
16.8 9.1 16.7 42.6
18.9 10.1 18.1 47.1
260.3 49.1 (NA) 6.1 (NA) 315.5
658.1 109.0 85.5 7.8 15.7 876.1
713.9 120.4 (NA) 8.2 (NA) 842.5
733.2 779.3 832.4 876.9 908.9 965.4 1027 1101.8 1175.8 1206 1,248.0 1,300.2 1,361.5 124.6 136.0 150.3 158.6 169.4 182.0 192.5 206.3 215.5 226.7 246.4 264.0 282.1 (NA) 108.64 120.5 126.4 134.5 144.0 151.5 160.5 165.8 172.9 186.4 199.9 217.5 8.2 8.4 8.7 8.5 7.4 7.1 7.5 7.9 8.3 8.3 9.5 9.7 9.5 (NA) 18.95 21.1 23.8 27.5 30.8 33.5 37.8 41.4 45.5 50.5 54.4 55.1 866.0 1051.2 1133.0 1194.2 1247.7 1329.3 1412.0 1514.3 1606.8 1659.4 1740.8 1828.2 1925.7
90.0 82.6 28.9 201.5
220.2 205.6 94.1 519.9
236.2 220.6 103.1 559.9
246.1 230.7 97.4 574.2
256.0 240.4 102.9 599.3
271.9 256.5 107.6 636.0
285.1 269.5 113.3 667.9
297.0 280.8 102.1 679.9
309.5 291.0 104.8 705.3
325.5 307.2 110.3 743.0
347 328.1 122.9 798.0
368.3 348.2 138.5 855.0
374.5 354.3 137.3 866.1
377.1 358.1 137.0 872.2
382.7 363.6 141.7 888.0
394.2 374.6 148.9 917.7
22.1 4.5 8.2 7.1 4.4 4.5 50.8
49.3 7.7 17.6 15.9 10.8 10.5 111.8
54.0 7.9 19.1 17.2 12.3 11.8 122.3
55.6 7.8 20.0 18.2 13.7 11.4 126.7
60.2 8.0 21.8 19.9 15.4 11.9 137.2
64.3 8.2 23.8 21.2 16.4 12.3 146.2
70.2 8.5 26.1 23.6 17.8 13.1 159.3
75.6 8.6 28.6 25.7 19.3 13.9 171.7
79.3 9.0 29.2 26.4 21.5 14.6 180.0
85.3 9.8 30.6 27.4 23.9 15.4 192.4
92.3 10.5 32.2 29 26.4 17.3 207.7
95.8 10.5 32.8 29.8 28.4 18 215.3
97.4 10.4 32.9 29.9 30.5 17.5 218.6
104.2 10.2 35.8 31.8 33.2 18.1 233.3
107.4 10.0 36.3 32.4 35.4 18.5 240.0
110.4 10.1 34.8 30.6 38.2 19.3 243.4
30.5 25.5 (NA) (NA) (NA) 56.0
90.1 80.4 (NA) (NA) (NA) 170.5
98.1 88.2 (NA) (NA) (NA) 186.3
104.6 95.1 (NA) (NA) (NA) 199.7
113.3 103.6 60.96 41.6 9.64 329.1
121.3 111.5 66.0 44.4 9.8 353.0
127.9 117.6 68.2 48.1 10.3 372.1
139.4 128.6 75.2 51.6 10.9 405.7
153.5 142.6 81.1 59.6 10.8 447.6
168 157.1 87.7 67 10.9 490.7
177.8 167.2 92.9 71.5 10.7 520.1
190.1 178.7 99.9 75.7 11.5 555.9
194.4 182.6 102.4 77.2 11.8 568.4
200.2 187.8 103.6 81.5 12.4 585.5
212.8 200.5 108.9 88.9 12.3 623.4
222.1 210.2 114.8 92.6 11.9 651.6
14.6 8.4 9.1 (NA) (NA) 32.1
31.0 16.9 22.8 (NA) (NA) 70.7
34.0 17.7 23.6 (NA) (NA) 75.3
36.4 18.1 23.8 (NA) (NA) 78.3
40.6 19.1 25.3 12.81 (NA) 97.8
44.0 18.3 27.8 15.0 16.8 121.9
47.0 19.5 28.3 15.8 16.8 127.4
50.5 19.9 30.3 17.2 14.1 132.0
54.1 19.8 35.9 20.8 14.5 145.1
57.8 19.6 40.5 23.9 14.8 156.6
63.3 20.1 43.6 26.2 14.7 167.9
70.6 21.7 45.6 26.6 15.6 180.1
75.5 22.5 49.1 30 14.6 191.7
77.8 21.7 55.2 35.5 14.2 204.4
79.7 21.6 60.6 40.5 15.0 217.4
82.0 22.1 68.7 46.3 15.9 235.0
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
*Note: From http://www.census.gov/econ/www/retmenu.html
540.7 77.1 56.5 10.7 685.0
1987
324.8 52.2 35.7 8.5 421.2
Source: U.S. Census Bureau, Current Business Reports, Annual Benchmark Report for Retail Trade, January 1990 Through December 1999, (BR/99-A) and prior issues.
498.1 71.2 50.8 10.5 630.6
1986
299.2 50.8 35.0 8.3 393.3
X Not applicable. NA Not available. \1 Based on 1987 Standard Industrial Classification code; see text, Section 13, Labor Force. \2 Includes kinds of business, not shown separately. \3 Excludes leased departments.
454.5 67.1 47.1 10.4 579.1
1985
114.8 18.1 11.3 3.0 147.2
Footnotes:
390.85 58.7 41.3 9.1 500.0
1984
781.9 886.7 110.7 125.2 83.1 94.6 13.1 13.8 988.8 1120.3
230.0 273.3 303.2 326.1 342.9 372.6 386 387.6 372.6 406.9 459.3 525.3 207.9 250.2 278.0 301.1 316.3 343.2 356.5 356.8 343 377.1 428.5 492.4 198.0 236.7 263.1 284.5 298.8 324.9 337.7 338.7 325.2 359.3 408.1 469.1 187.7 225.9 251.6 270.4 280.5 303.3 311.6 316 301.3 333.8 379.5 435.7 22.1 23.1 25.2 25.1 26.6 29.4 29.5 30.8 29.6 29.8 30.8 32.9 845.7 1009.2 1121.1 1207.2 1265.1 1373.4 1421.3 1429.9 1371.7 1506.9 1706.2 1955.4
Retail Trade Data: Outline By Applying Subtotals No. 1275. Retail Trade--Sales, by Kind of Business
Note: The data is now in Excel list format. That is, There's a header row. Each row is a record, or information about one entity. There are no blank [In billions of dollars (375.2 represents $375,200,000,000). Sales and inventories for leased departments columns or rows in the data. The data can be subtotalled, and concessions are tabulated in the kind-of-business category of the leased department or concession. and that automatically adds outlining and sub and grand Based on Current Business Survey, see Appendix III and summary below.] totals.
Business
Business Type 1970
New and used car dealers Durable goods stores, total \2 Floor covering stores Furniture stores Household appliance stores Motor vehicle dealers Nondurable goods stores, total \2 Radio, TV, and computer stores Refreshment places Restaurants, lunchrooms, cafeterias Women's clothing stores Appliance, radio, TV, & computer stores Auto and home supply stores Building materials, supply stores Catalog and mail-order houses Department stores \3 Drinking places Eating places \2 Family clothing stores Furniture, homefurnishings stores \2 Grocery stores Hardware stores Men's and boys' clothing stores Misc. general merchandise stores Motor vehicle, misc. automotive dealers Shoe stores Variety stores Women's clothing specialty stores Apparel and accessory stores \2 Automotive dealers Book stores Building materials and garden supplies \2 Drug stores and proprietary stores Eating and drinking places Food stores Fuel dealers Furniture and homefurnishings stores \2 Gasoline service stations General merchandise stores Jewelry stores Liquor stores Nonstore retailers Sporting goods and bicycle shops
Automotive Durables Household Household Household Automotive Nondurables Household Food Service Food Service Apparel Household Automotive Durables Specialty Nondurables Food Service Food Service Apparel Household Food Durables Apparel Nondurables Automotive Apparel Nondurables Apparel Apparel Automotive Leisure Durables Specialty Food Service Food Specialty Household Food Nondurables Leisure Specialty Specialty Leisure
54.3 114.8 (NA) (NA) (NA) 57.2 260.3 (NA) (NA) (NA) 7.1 5.6 6.0 11.3 (NA) (NA) (NA) 25.5 4.4 10.4 82.6 3.0 4.5 (NA) 59.2 4.5 6.1 8.2 22.1 65.2 (NA) 18.1 14.6 30.5 90.0 (NA) 17.0 28.9 49.1 (NA) 8.4 9.1 (NA)
1980 130.5 299.2 (NA) (NA) (NA) 137.7 658.1 (NA) (NA) (NA) 15.9 14.0 18.0 35.0 (NA) 85.5 (NA) 80.4 10.8 26.3 205.6 8.3 7.7 15.7 146.2 10.5 7.8 17.6 49.3 164.1 (NA) 50.8 31.0 90.1 220.2 (NA) 44.2 94.1 109.0 (NA) 16.9 22.8 (NA)
1981 144.5 324.8 (NA) (NA) (NA) 153.0 713.9 (NA) (NA) (NA) 17.2 15.4 19.6 35.7 (NA) (NA) (NA) 88.2 12.3 27.5 220.6 8.5 7.9 (NA) 162.3 11.8 8.2 19.1 54.0 181.9 (NA) 52.2 34.0 98.1 236.2 (NA) 46.9 103.1 120.4 (NA) 17.7 23.6 (NA)
1982 154.7 336.2 (NA) (NA) (NA) 162.9 733.2 (NA) (NA) (NA) 18.2 15.8 20.1 35.1 (NA) (NA) (NA) 95.1 13.7 27.1 230.7 8.7 7.8 (NA) 172.4 11.4 8.2 20.0 55.6 192.4 (NA) 51.0 36.4 104.6 246.1 (NA) 46.8 97.4 124.6 (NA) 18.1 23.8 (NA)
1983 187.7 390.85 (NA) 19.79 6.73 198.0 779.3 12.55 41.6 60.96 19.9 19.3 22.1 41.3 12.81 108.64 9.64 103.6 15.4 31.3 240.4 9.1 8.0 18.95 207.9 11.9 8.4 21.8 60.2 230.0 (NA) 58.7 40.6 113.3 256.0 (NA) 54.7 102.9 136.0 9.6 19.1 25.3 (NA)
1984 225.9 454.5 7.6 22.3 7.4 236.7 832.4 14.1 44.4 66.0 21.2 21.5 23.1 47.1 15.0 120.5 9.8 111.5 16.4 35.6 256.5 10.4 8.2 21.1 250.2 12.3 8.7 23.8 64.3 273.3 4.1 67.1 44.0 121.3 271.9 16.8 61.4 107.6 150.3 10.8 18.3 27.8 8.3
1985 251.6 498.1 7.9 23.9 8.4 263.1 876.9 16.7 48.1 68.2 23.6 25.1 25.2 50.8 15.8 126.4 10.3 117.6 17.8 38.3 269.5 10.5 8.5 23.8 278.0 13.1 8.5 26.1 70.2 303.2 4.5 71.2 47.0 127.9 285.1 16.8 68.3 113.3 158.6 11.2 19.5 28.3 8.7
1986 270.4 540.7 8.7 26.0 9.3 284.5 908.9 17.8 51.6 75.2 25.7 27.0 25.1 56.5 17.2 134.5 10.9 128.6 19.3 43.0 280.8 10.7 8.6 27.5 301.1 13.9 7.4 28.6 75.6 326.1 4.8 77.1 50.5 139.4 297.0 14.1 75.7 102.1 169.4 12.2 19.9 30.3 9.2
1987 280.5 575.9 9.9 26.7 8.6 298.8 965.4 18.5 59.6 81.1 26.4 27.1 26.6 61.3 20.8 144.0 10.8 142.6 21.5 44.5 291.0 11.0 9.0 30.8 316.3 14.6 7.1 29.2 79.3 342.9 5.3 83.5 54.1 153.5 309.5 14.5 78.1 104.8 182.0 12.9 19.8 35.9 11.3
1988 303.3 629.2 11.1 28.2 8.7 324.9 1027 21.9 67 87.7 27.4 30.6 29.4 66.8 23.9 151.5 10.9 157.1 23.9 47.6 307.2 11.9 9.8 33.5 343.2 15.4 7.5 30.6 85.3 372.6 6 91.1 57.8 168 325.5 14.8 85.4 110.3 192.5 14.3 19.6 40.5 12.8
1989 311.6 657.2 10.7 31.9 9.3 337.7 1101.8 23.4 71.5 92.9 29 32.7 29.5 67.5 26.2 160.5 10.7 167.2 26.4 51.2 328.1 12.6 10.5 37.8 356.5 17.3 7.9 32.2 92.3 386 6.5 92.4 63.3 177.8 347 14.7 91.3 122.9 206.3 14.4 20.1 43.6 14.2
1990 316 668.8 10.7 30.8 8.8 338.7 1175.8 24.3 75.7 99.9 29.8 33 30.8 70.3 26.6 165.8 11.5 178.7 28.4 50.5 348.2 12.5 10.5 41.4 356.8 18 8.3 32.8 95.8 387.6 7.4 94.6 70.6 190.1 368.3 15.6 91.5 138.5 215.5 15.2 21.7 45.6 15
1991 1992 1993 1994 301.3 333.8 379.5 435.7 650 703.6 781.9 886.7 10.1 10.4 10.8 11.7 30.2 31.2 32.8 34.8 8.3 8.4 9.1 9.0 325.2 359.3 408.1 469.1 1206 1,248.0 1,300.2 1,361.5 25.3 27.4 32.2 40.5 77.2 81.5 88.9 92.6 102.4 103.6 108.9 114.8 29.9 31.8 32.4 30.6 33.6 35.8 41.3 49.5 29.6 29.8 30.8 32.9 68.2 75.4 83.1 94.6 30 35.5 40.5 46.3 172.9 186.4 199.9 217.5 11.8 12.4 12.3 11.9 182.6 187.8 200.5 210.2 30.5 33.2 35.4 38.2 49.5 52.3 54.8 59.2 354.3 358.1 363.6 374.6 12.1 12.7 13.1 13.8 10.4 10.2 10.0 10.1 45.5 50.5 54.4 55.1 343 377.1 428.5 492.4 17.5 18.1 18.5 19.3 8.3 9.5 9.7 9.5 32.9 35.8 36.3 34.8 97.4 104.2 107.4 110.4 372.6 406.9 459.3 525.3 7.7 8.3 9.1 10.1 91.5 100.8 110.7 125.2 75.5 77.8 79.7 82.0 194.4 200.2 212.8 222.1 374.5 377.1 382.7 394.2 14.6 14.2 15.0 15.9 91.7 96.9 105.5 119.1 137.3 137.0 141.7 148.9 226.7 246.4 264.0 282.1 14.8 15.3 16.7 18.1 22.5 21.7 21.6 22.1 49.1 55.2 60.6 68.7 15.1 15.6 16.8 18.9
Retail Trade Data: Outlined Using Subtotals No. 1275. Retail Trade--Sales, by Kind of Business
Note: See the sample subtotal dialog at right. Sort before applying subtotals. Here, the data grouped using the "Business Type" field. [In billions of dollars (375.2 represents $375,200,000,000). Sales and inventories for leasedisdepartments are calculated for each year. and concessions are tabulated in the kind-of-business category of the leased department orSums concession. Based on Current Business Survey, see Appendix III and summary below.]
Business Women's clothing stores Family clothing stores Men's and boys' clothing stores Shoe stores Women's clothing specialty stores Apparel and accessory stores \2
Business Type 1970
Apparel 7.1 Apparel 4.4 Apparel 4.5 Apparel 4.5 Apparel 8.2 Apparel 22.1 Apparel Total 50.8 New and used car dealers Automotive 54.3 Motor vehicle dealers Automotive 57.2 Auto and home supply stores Automotive 6.0 Motor vehicle, misc. automotive dealers Automotive 59.2 Automotive dealers Automotive 65.2 Automotive Total 241.9 Durable goods stores, total \2 Durables 114.8 Building materials, supply stores Durables 11.3 Hardware stores Durables 3.0 Building materials and garden supplies \2 Durables 18.1 Durables Total 147.2 Grocery stores Food 82.6 Food stores Food 90.0 Gasoline service stations Food 28.9 Food Total 201.5 Refreshment places Food Service (NA) Restaurants, lunchrooms, cafeterias Food Service (NA) Drinking places Food Service (NA) Eating places \2 Food Service 25.5 Eating and drinking places Food Service 30.5 Food Service Total 56.0 Floor covering stores Household (NA) Furniture stores Household (NA) Household appliance stores Household (NA) Radio, TV, and computer stores Household (NA) Appliance, radio, TV, & computer stores Household 5.6 Furniture, homefurnishings stores \2 Household 10.4 Furniture and homefurnishings stores \2 Household 17.0 Household Total 33.0 Book stores Leisure (NA) Jewelry stores Leisure (NA) Sporting goods and bicycle shops Leisure (NA) Leisure Total 0 Nondurable goods stores, total \2 Nondurables 260.3 Department stores \3 Nondurables (NA) Misc. general merchandise stores Nondurables (NA) Variety stores Nondurables 6.1 General merchandise stores Nondurables 49.1 Nondurables Total 315.5 Catalog and mail-order houses Specialty (NA) Drug stores and proprietary stores Specialty 14.6 Fuel dealers Specialty (NA) Liquor stores Specialty 8.4 Nonstore retailers Specialty 9.1 Specialty Total 32.1 Grand Total 1078.0
1980 1981 1982 15.9 17.2 18.2 10.8 12.3 13.7 7.7 7.9 7.8 10.5 11.8 11.4 17.6 19.1 20.0 49.3 54.0 55.6 111.8 122.3 126.7 130.5 144.5 154.7 137.7 153.0 162.9 18.0 19.6 20.1 146.2 162.3 172.4 164.1 181.9 192.4 596.5 661.3 702.5 299.2 324.8 336.2 35.0 35.7 35.1 8.3 8.5 8.7 50.8 52.2 51.0 393.3 421.2 431.0 205.6 220.6 230.7 220.2 236.2 246.1 94.1 103.1 97.4 519.9 559.9 574.2 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 80.4 88.2 95.1 90.1 98.1 104.6 170.5 186.3 199.7 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 14.0 15.4 15.8 26.3 27.5 27.1 44.2 46.9 46.8 84.5 89.8 89.7 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 0 0 0 658.1 713.9 733.2 85.5 (NA) (NA) 15.7 (NA) (NA) 7.8 8.2 8.2 109.0 120.4 124.6 876.1 842.5 866.0 (NA) (NA) (NA) 31.0 34.0 36.4 (NA) (NA) (NA) 16.9 17.7 18.1 22.8 23.6 23.8 70.7 75.3 78.3 2823.3 2,958.6 3,068.1
1983 19.9 15.4 8.0 11.9 21.8 60.2 137.2 187.7 198.0 22.1 207.9 230.0 845.7 390.85 41.3 9.1 58.7 500.0 240.4 256.0 102.9 599.3 41.6 60.96 9.64 103.6 113.3 329.1 (NA) 19.79 6.73 12.55 19.3 31.3 54.7 144.3 (NA) 9.6 (NA) 9.6 779.3 108.64 18.95 8.4 136.0 1051.2 12.81 40.6 (NA) 19.1 25.3 97.8 3714.3
1984 21.2 16.4 8.2 12.3 23.8 64.3 146.2 225.9 236.7 23.1 250.2 273.3 1009.2 454.5 47.1 10.4 67.1 579.1 256.5 271.9 107.6 636.0 44.4 66.0 9.8 111.5 121.3 353.0 7.6 22.3 7.4 14.1 21.5 35.6 61.4 169.9 4.1 10.8 8.3 23.2 832.4 120.5 21.1 8.7 150.3 1133.0 15.0 44.0 16.8 18.3 27.8 121.9 4171.5
1985 23.6 17.8 8.5 13.1 26.1 70.2 159.3 251.6 263.1 25.2 278.0 303.2 1121.1 498.1 50.8 10.5 71.2 630.6 269.5 285.1 113.3 667.9 48.1 68.2 10.3 117.6 127.9 372.1 7.9 23.9 8.4 16.7 25.1 38.3 68.3 188.6 4.5 11.2 8.7 24.4 876.9 126.4 23.8 8.5 158.6 1194.2 15.8 47.0 16.8 19.5 28.3 127.4 4485.6
1986 25.7 19.3 8.6 13.9 28.6 75.6 171.7 270.4 284.5 25.1 301.1 326.1 1207.2 540.7 56.5 10.7 77.1 685.0 280.8 297.0 102.1 679.9 51.6 75.2 10.9 128.6 139.4 405.7 8.7 26.0 9.3 17.8 27.0 43.0 75.7 207.5 4.8 12.2 9.2 26.2 908.9 134.5 27.5 7.4 169.4 1247.7 17.2 50.5 14.1 19.9 30.3 132.0 4762.9
1987 26.4 21.5 9.0 14.6 29.2 79.3 180.0 280.5 298.8 26.6 316.3 342.9 1265.1 575.9 61.3 11.0 83.5 731.7 291.0 309.5 104.8 705.3 59.6 81.1 10.8 142.6 153.5 447.6 9.9 26.7 8.6 18.5 27.1 44.5 78.1 213.4 5.3 12.9 11.3 29.5 965.4 144.0 30.8 7.1 182.0 1329.3 20.8 54.1 14.5 19.8 35.9 145.1 5047.0
1988 27.4 23.9 9.8 15.4 30.6 85.3 192.4 303.3 324.9 29.4 343.2 372.6 1373.4 629.2 66.8 11.9 91.1 799 307.2 325.5 110.3 743 67 87.7 10.9 157.1 168 490.7 11.1 28.2 8.7 21.9 30.6 47.6 85.4 233.5 6 14.3 12.8 33.1 1027 151.5 33.5 7.5 192.5 1412 23.9 57.8 14.8 19.6 40.5 156.6 5433.7
1989 29 26.4 10.5 17.3 32.2 92.3 207.7 311.6 337.7 29.5 356.5 386 1421.3 657.2 67.5 12.6 92.4 829.7 328.1 347 122.9 798 71.5 92.9 10.7 167.2 177.8 520.1 10.7 31.9 9.3 23.4 32.7 51.2 91.3 250.5 6.5 14.4 14.2 35.1 1101.8 160.5 37.8 7.9 206.3 1514.3 26.2 63.3 14.7 20.1 43.6 167.9 5744.6
1990 29.8 28.4 10.5 18 32.8 95.8 215.3 316 338.7 30.8 356.8 387.6 1429.9 668.8 70.3 12.5 94.6 846.2 348.2 368.3 138.5 855 75.7 99.9 11.5 178.7 190.1 555.9 10.7 30.8 8.8 24.3 33 50.5 91.5 249.6 7.4 15.2 15 37.6 1175.8 165.8 41.4 8.3 215.5 1606.8 26.6 70.6 15.6 21.7 45.6 180.1 5976.4
1991 29.9 30.5 10.4 17.5 32.9 97.4 218.6 301.3 325.2 29.6 343 372.6 1371.7 650 68.2 12.1 91.5 821.8 354.3 374.5 137.3 866.1 77.2 102.4 11.8 182.6 194.4 568.4 10.1 30.2 8.3 25.3 33.6 49.5 91.7 248.7 7.7 14.8 15.1 37.6 1206 172.9 45.5 8.3 226.7 1659.4 30 75.5 14.6 22.5 49.1 191.7 5984
1992 31.8 33.2 10.2 18.1 35.8 104.2 233.3 333.8 359.3 29.8 377.1 406.9 1,506.9 703.6 75.4 12.7 100.8 892.5 358.1 377.1 137.0 872.2 81.5 103.6 12.4 187.8 200.2 585.5 10.4 31.2 8.4 27.4 35.8 52.3 96.9 262.4 8.3 15.3 15.6 39.2 1,248.0 186.4 50.5 9.5 246.4 1,740.8 35.5 77.8 14.2 21.7 55.2 204.4 6,337.2
1993 32.4 35.4 10.0 18.5 36.3 107.4 240.0 379.5 408.1 30.8 428.5 459.3 1,706.2 781.9 83.1 13.1 110.7 988.8 363.6 382.7 141.7 888.0 88.9 108.9 12.3 200.5 212.8 623.4 10.8 32.8 9.1 32.2 41.3 54.8 105.5 286.5 9.1 16.7 16.8 42.6 1,300.2 199.9 54.4 9.7 264.0 1,828.2 40.5 79.7 15.0 21.6 60.6 217.4 6,821.1
1994 30.6 38.2 10.1 19.3 34.8 110.4 243.4 435.7 469.1 32.9 492.4 525.3 1,955.4 886.7 94.6 13.8 125.2 1,120.3 374.6 394.2 148.9 917.7 92.6 114.8 11.9 210.2 222.1 651.6 11.7 34.8 9.0 40.5 49.5 59.2 119.1 323.8 10.1 18.1 18.9 47.1 1,361.5 217.5 55.1 9.5 282.1 1,925.7 46.3 82.0 15.9 22.1 68.7 235.0 7,420.0
An Agenda An agenda is the kind of hierarchical data that can make use of Excel's outlining mode. Since there are no calculations in this data, outlining must be applied manually.
Agenda Day 1 Dinner Opening Remarks Day 2 Breakfast Cocktails Opening Remarks Morning Address Morning Breakout Sessions Skiing Professionally Jean Claude Killy Martin Kennedy-Kilo Jaqueline Vitesse Opportunities with Beach Umbrellas Carribean Caspian Mediterranean Multi-Story Birdhouse Production A Bluebird Focus Grackle Retirement Communities Sparrow Getaways Lunch Vegetarian Vegan Ovo-Lacto Fruitarian Omnivorian Desertarian Afternoon Address Afternoon Breakout Sessions Financing Your Ski Career Moving Beyond Umbrellas Virtual Ornithological Housing Dinner Closing Remarks Condensed Expanded Day 3 Breakfast Departing Remarks
An Agenda Outlined Use the commands Data, Group and Outline, Groupto add outlining. Start by grouping the most detailed items first, then working out to the least detailed.
Agenda Day 1 Dinner Opening Remarks Day 2 Breakfast Cocktails Opening Remarks Morning Address Morning Breakout Sessions Skiing Professionally Jean Claude Killy Martin Kennedy-Kilo Jaqueline Vitesse Opportunities with Beach Umbrellas Carribean Caspian Mediterranean Multi-Story Birdhouse Production A Bluebird Focus Grackle Retirement Communities Sparrow Getaways Lunch Vegetarian Vegan Ovo-Lacto Fruitarian Omnivorian Desertarian Afternoon Address Afternoon Breakout Sessions Financing Your Ski Career Moving Beyond Umbrellas Virtual Ornithological Housing Dinner Closing Remarks Day 3 Breakfast Departing Remarks
Worksheet Views Your worksheet may have several layouts, each one useful. If you want to save each layout with a name so you can easily call it up, use a "View". To create a view 1. Establish the layout (and formatting) of the worksheet. 2. From the menus choose View, Custom Views. 3. Click the "Add" button to open the "Add View" dialog. 4. Give your view a name and click the "OK" button. Repeat to create any number of different views for a sheet. To see a view Choose View, Custom Views and select the layout you want from its name in the list. To delete a view Choose View, Custom Views, select the view to delete from the list, and click the "Delete" button.
Using Custom Views: Samples Choose View, Custom Views to see the two views established for this worksheet. Select either the "Basic Agenda" or the "Complete Agenda" from the list that displays.
Agenda Day 1 Day 2 Day 3 Breakfast Departing Remarks
10/17/2008
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 1-Companions and 2-Cpns Outlined Automatically Data w/no existing summary formulas, but in a format suitable for automatic outlining. 3-Retail Trade and 4-Retail Trade Auto Outlined Data with summary formulas, auto outlined. 5-Retail Trade as List and 6-Rtl Trade Subtotalled Retail trade data but in list format, with no summary formulas. Subtotalling provides outline. 7-Agenda and 8-Outlined Agenda 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.
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) The data in Excel list format.
Animal Bird Bird Bird Bird Bird Bird Bird Cat Cat Cat Cat Cat Cat Cat Dog Dog Dog Dog Dog Dog Dog Horse Horse Horse Horse Horse Horse Horse
Year 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999
*Based on data at: http://www.avma.org
Number 5 5.7 5.7 4.9 3.2 4.1 2.2 28.4 42.6 48.2 31.2 50.5 29.9 33.5 42.5 38.2 36.5 39.4 42.3 45.1 40.3 2.8 2.8 2 2.2 2.5 2.8 3.1
Companion Animals: Outlined Automatically Number of households aquiring companion animals by year (millions) Animal Bird Bird Bird Bird Bird Bird Bird Bird Total Cat Cat Cat Cat Cat Cat Cat Cat Total Dog Dog Dog Dog Dog Dog Dog Dog Total Horse Horse Horse Horse Horse Horse Horse Horse Total Grand Total
Year 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999 1993 1994 1995 1996 1997 1998 1999
Number 5 5.7 5.7 4.9 3.2 4.1 2.2 30.8 28.4 42.6 48.2 31.2 50.5 29.9 33.5 264.3 42.5 38.2 36.5 39.4 42.3 45.1 40.3 284.3 2.8 2.8 2 2.2 2.5 2.8 3.1 18.2 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. Based on Current Business Survey, see Appendix III and summary below.]
Business Durable Goods Durable goods stores, total \2 Building materials and garden supplies \2 Building materials, supply stores Hardware stores Durable Goods Totals Automotive Automotive dealers Motor vehicle, misc. automotive dealers Motor vehicle dealers New and used car dealers Auto and home supply stores Automotive Totals Household Furniture and homefurnishings stores \2 Furniture, homefurnishings stores \2 Furniture stores Floor covering stores Appliance, radio, TV, & computer stores Household appliance stores Radio, TV, and computer stores Household Totals Leisure Sporting goods and bicycle shops Book stores Jewelry stores Leisure Totals Nondurable Goods Nondurable goods stores, total \2 General merchandise stores Department stores \3 Variety stores Misc. general merchandise stores Nondurable Goods Totals Food Food stores Grocery stores Gasoline service stations Food Totals Apparel Apparel and accessory stores \2 Men's and boys' clothing stores Women's clothing specialty stores Women's clothing stores Family clothing stores Shoe stores Apparel Totals Food Eating and drinking places Eating places \2 Restaurants, lunchrooms, cafeterias Refreshment places Drinking places Food Service Totals Specialty Drug stores and proprietary stores Liquor stores Nonstore retailers Catalog and mail-order houses Fuel dealers Specialty Sales Totals Grand Totals
1970
1980
1981
1982
1983
575.9 83.5 61.3 11.0 731.7
1988 629.2 91.1 66.8 11.9 799.0
1989 657.2 92.4 67.5 12.6 829.7
1990 668.8 94.6 70.3 12.5 846.2
1991 650 91.5 68.2 12.1 821.8
1992 703.6 100.8 75.4 12.7 892.5
1993
1994
336.2 51.0 35.1 8.7 431.0
65.2 59.2 57.2 54.3 6.0 241.9
164.1 146.2 137.7 130.5 18.0 596.5
181.9 162.3 153.0 144.5 19.6 661.3
192.4 172.4 162.9 154.7 20.1 702.5
17.0 10.4 (NA) (NA) 5.6 (NA) (NA) 33.0
44.2 26.3 (NA) (NA) 14.0 (NA) (NA) 84.5
46.9 27.5 (NA) (NA) 15.4 (NA) (NA) 89.8
46.8 27.1 (NA) (NA) 15.8 (NA) (NA) 89.7
54.7 31.3 19.79 (NA) 19.3 6.73 12.55 144.3
61.4 35.6 22.3 7.6 21.5 7.4 14.1 169.9
68.3 38.3 23.9 7.9 25.1 8.4 16.7 188.6
75.7 43.0 26.0 8.7 27.0 9.3 17.8 207.5
78.1 44.5 26.7 9.9 27.1 8.6 18.5 213.4
85.4 47.6 28.2 11.1 30.6 8.7 21.9 233.5
91.3 51.2 31.9 10.7 32.7 9.3 23.4 250.5
91.5 50.5 30.8 10.7 33 8.8 24.3 249.6
91.7 49.5 30.2 10.1 33.6 8.3 25.3 248.7
96.9 52.3 31.2 10.4 35.8 8.4 27.4 262.4
105.5 54.8 32.8 10.8 41.3 9.1 32.2 286.5
119.1 59.2 34.8 11.7 49.5 9.0 40.5 323.8
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) 9.6 9.6
8.3 4.1 10.8 23.2
8.7 4.5 11.2 24.4
9.2 4.8 12.2 26.2
11.3 5.3 12.9 29.5
12.8 6 14.3 33.1
14.2 6.5 14.4 35.1
15 7.4 15.2 37.6
15.1 7.7 14.8 37.6
15.6 8.3 15.3 39.2
16.8 9.1 16.7 42.6
18.9 10.1 18.1 47.1
260.3 49.1 (NA) 6.1 (NA) 315.5
658.1 109.0 85.5 7.8 15.7 876.1
713.9 120.4 (NA) 8.2 (NA) 842.5
733.2 779.3 832.4 876.9 908.9 965.4 1027 1101.8 1175.8 1206 1,248.0 1,300.2 1,361.5 124.6 136.0 150.3 158.6 169.4 182.0 192.5 206.3 215.5 226.7 246.4 264.0 282.1 (NA) 108.64 120.5 126.4 134.5 144.0 151.5 160.5 165.8 172.9 186.4 199.9 217.5 8.2 8.4 8.7 8.5 7.4 7.1 7.5 7.9 8.3 8.3 9.5 9.7 9.5 (NA) 18.95 21.1 23.8 27.5 30.8 33.5 37.8 41.4 45.5 50.5 54.4 55.1 866.0 1051.2 1133.0 1194.2 1247.7 1329.3 1412.0 1514.3 1606.8 1659.4 1740.8 1828.2 1925.7
90.0 82.6 28.9 201.5
220.2 205.6 94.1 519.9
236.2 220.6 103.1 559.9
246.1 230.7 97.4 574.2
256.0 240.4 102.9 599.3
271.9 256.5 107.6 636.0
285.1 269.5 113.3 667.9
297.0 280.8 102.1 679.9
309.5 291.0 104.8 705.3
325.5 307.2 110.3 743.0
347 328.1 122.9 798.0
368.3 348.2 138.5 855.0
374.5 354.3 137.3 866.1
377.1 358.1 137.0 872.2
382.7 363.6 141.7 888.0
394.2 374.6 148.9 917.7
22.1 4.5 8.2 7.1 4.4 4.5 50.8
49.3 7.7 17.6 15.9 10.8 10.5 111.8
54.0 7.9 19.1 17.2 12.3 11.8 122.3
55.6 7.8 20.0 18.2 13.7 11.4 126.7
60.2 8.0 21.8 19.9 15.4 11.9 137.2
64.3 8.2 23.8 21.2 16.4 12.3 146.2
70.2 8.5 26.1 23.6 17.8 13.1 159.3
75.6 8.6 28.6 25.7 19.3 13.9 171.7
79.3 9.0 29.2 26.4 21.5 14.6 180.0
85.3 9.8 30.6 27.4 23.9 15.4 192.4
92.3 10.5 32.2 29 26.4 17.3 207.7
95.8 10.5 32.8 29.8 28.4 18 215.3
97.4 10.4 32.9 29.9 30.5 17.5 218.6
104.2 10.2 35.8 31.8 33.2 18.1 233.3
107.4 10.0 36.3 32.4 35.4 18.5 240.0
110.4 10.1 34.8 30.6 38.2 19.3 243.4
30.5 25.5 (NA) (NA) (NA) 56.0
90.1 80.4 (NA) (NA) (NA) 170.5
98.1 88.2 (NA) (NA) (NA) 186.3
104.6 95.1 (NA) (NA) (NA) 199.7
113.3 103.6 60.96 41.6 9.64 329.1
121.3 111.5 66.0 44.4 9.8 353.0
127.9 117.6 68.2 48.1 10.3 372.1
139.4 128.6 75.2 51.6 10.9 405.7
153.5 142.6 81.1 59.6 10.8 447.6
168 157.1 87.7 67 10.9 490.7
177.8 167.2 92.9 71.5 10.7 520.1
190.1 178.7 99.9 75.7 11.5 555.9
194.4 182.6 102.4 77.2 11.8 568.4
200.2 187.8 103.6 81.5 12.4 585.5
212.8 200.5 108.9 88.9 12.3 623.4
222.1 210.2 114.8 92.6 11.9 651.6
14.6 8.4 9.1 (NA) (NA) 32.1
31.0 16.9 22.8 (NA) (NA) 70.7
34.0 17.7 23.6 (NA) (NA) 75.3
36.4 18.1 23.8 (NA) (NA) 78.3
40.6 19.1 25.3 12.81 (NA) 97.8
44.0 18.3 27.8 15.0 16.8 121.9
47.0 19.5 28.3 15.8 16.8 127.4
50.5 19.9 30.3 17.2 14.1 132.0
54.1 19.8 35.9 20.8 14.5 145.1
57.8 19.6 40.5 23.9 14.8 156.6
63.3 20.1 43.6 26.2 14.7 167.9
70.6 21.7 45.6 26.6 15.6 180.1
75.5 22.5 49.1 30 14.6 191.7
77.8 21.7 55.2 35.5 14.2 204.4
79.7 21.6 60.6 40.5 15.0 217.4
82.0 22.1 68.7 46.3 15.9 235.0
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
*Note: From http://www.census.gov/econ/www/retmenu.html
540.7 77.1 56.5 10.7 685.0
1987
324.8 52.2 35.7 8.5 421.2
Source: U.S. Census Bureau, Current Business Reports, Annual Benchmark Report for Retail Trade, January 1990 Through December 1999, (BR/99-A) and prior issues.
498.1 71.2 50.8 10.5 630.6
1986
299.2 50.8 35.0 8.3 393.3
X Not applicable. NA Not available. \1 Based on 1987 Standard Industrial Classification code; see text, Section 13, Labor Force. \2 Includes kinds of business, not shown separately. \3 Excludes leased departments.
454.5 67.1 47.1 10.4 579.1
1985
114.8 18.1 11.3 3.0 147.2
Footnotes:
390.85 58.7 41.3 9.1 500.0
1984
781.9 886.7 110.7 125.2 83.1 94.6 13.1 13.8 988.8 1120.3
230.0 273.3 303.2 326.1 342.9 372.6 386 387.6 372.6 406.9 459.3 525.3 207.9 250.2 278.0 301.1 316.3 343.2 356.5 356.8 343 377.1 428.5 492.4 198.0 236.7 263.1 284.5 298.8 324.9 337.7 338.7 325.2 359.3 408.1 469.1 187.7 225.9 251.6 270.4 280.5 303.3 311.6 316 301.3 333.8 379.5 435.7 22.1 23.1 25.2 25.1 26.6 29.4 29.5 30.8 29.6 29.8 30.8 32.9 845.7 1009.2 1121.1 1207.2 1265.1 1373.4 1421.3 1429.9 1371.7 1506.9 1706.2 1955.4
Retail Trade Data: Requires Manual Outlining No. 1275. Retail Trade--Sales, by Kind of Business*
Note: Because the summary lines are formulas, this data can be outlined automatically. Select the data and choose Data, Group and Outline, Auto Outline. Excel creates 3 [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 levels concession. of detail. Based on Current Business Survey, see Appendix III and summary below.]
Business Durable Goods Durable goods stores, total \2 Building materials and garden supplies \2 Building materials, supply stores Hardware stores Durable Goods Totals Automotive Automotive dealers Motor vehicle, misc. automotive dealers Motor vehicle dealers New and used car dealers Auto and home supply stores Automotive Totals Household Furniture and homefurnishings stores \2 Furniture, homefurnishings stores \2 Furniture stores Floor covering stores Appliance, radio, TV, & computer stores Household appliance stores Radio, TV, and computer stores Household Totals Leisure Sporting goods and bicycle shops Book stores Jewelry stores Leisure Totals Nondurable Goods Nondurable goods stores, total \2 General merchandise stores Department stores \3 Variety stores Misc. general merchandise stores Nondurable Goods Totals Food Food stores Grocery stores Gasoline service stations Food Totals Apparel Apparel and accessory stores \2 Men's and boys' clothing stores Women's clothing specialty stores Women's clothing stores Family clothing stores Shoe stores Apparel Totals Food Eating and drinking places Eating places \2 Restaurants, lunchrooms, cafeterias Refreshment places Drinking places Food Service Totals Specialty Drug stores and proprietary stores Liquor stores Nonstore retailers Catalog and mail-order houses Fuel dealers Specialty Sales Totals Grand Totals
1970
1980
1981
1982
1983
575.9 83.5 61.3 11.0 731.7
1988
629.2 91.1 66.8 11.9 799.0
1989
657.2 92.4 67.5 12.6 829.7
1990
668.8 94.6 70.3 12.5 846.2
1991
650 91.5 68.2 12.1 821.8
1992
703.6 100.8 75.4 12.7 892.5
1993
1994
336.2 51.0 35.1 8.7 431.0
65.2 59.2 57.2 54.3 6.0 241.9
164.1 146.2 137.7 130.5 18.0 596.5
181.9 162.3 153.0 144.5 19.6 661.3
192.4 172.4 162.9 154.7 20.1 702.5
17.0 10.4 (NA) (NA) 5.6 (NA) (NA) 33.0
44.2 26.3 (NA) (NA) 14.0 (NA) (NA) 84.5
46.9 27.5 (NA) (NA) 15.4 (NA) (NA) 89.8
46.8 27.1 (NA) (NA) 15.8 (NA) (NA) 89.7
54.7 31.3 19.79 (NA) 19.3 6.73 12.55 144.3
61.4 35.6 22.3 7.6 21.5 7.4 14.1 169.9
68.3 38.3 23.9 7.9 25.1 8.4 16.7 188.6
75.7 43.0 26.0 8.7 27.0 9.3 17.8 207.5
78.1 44.5 26.7 9.9 27.1 8.6 18.5 213.4
85.4 47.6 28.2 11.1 30.6 8.7 21.9 233.5
91.3 51.2 31.9 10.7 32.7 9.3 23.4 250.5
91.5 50.5 30.8 10.7 33 8.8 24.3 249.6
91.7 49.5 30.2 10.1 33.6 8.3 25.3 248.7
96.9 52.3 31.2 10.4 35.8 8.4 27.4 262.4
105.5 54.8 32.8 10.8 41.3 9.1 32.2 286.5
119.1 59.2 34.8 11.7 49.5 9.0 40.5 323.8
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) (NA) 0.0
(NA) (NA) 9.6 9.6
8.3 4.1 10.8 23.2
8.7 4.5 11.2 24.4
9.2 4.8 12.2 26.2
11.3 5.3 12.9 29.5
12.8 6 14.3 33.1
14.2 6.5 14.4 35.1
15 7.4 15.2 37.6
15.1 7.7 14.8 37.6
15.6 8.3 15.3 39.2
16.8 9.1 16.7 42.6
18.9 10.1 18.1 47.1
260.3 49.1 (NA) 6.1 (NA) 315.5
658.1 109.0 85.5 7.8 15.7 876.1
713.9 120.4 (NA) 8.2 (NA) 842.5
733.2 779.3 832.4 876.9 908.9 965.4 1027 1101.8 1175.8 1206 1,248.0 1,300.2 1,361.5 124.6 136.0 150.3 158.6 169.4 182.0 192.5 206.3 215.5 226.7 246.4 264.0 282.1 (NA) 108.64 120.5 126.4 134.5 144.0 151.5 160.5 165.8 172.9 186.4 199.9 217.5 8.2 8.4 8.7 8.5 7.4 7.1 7.5 7.9 8.3 8.3 9.5 9.7 9.5 (NA) 18.95 21.1 23.8 27.5 30.8 33.5 37.8 41.4 45.5 50.5 54.4 55.1 866.0 1051.2 1133.0 1194.2 1247.7 1329.3 1412.0 1514.3 1606.8 1659.4 1740.8 1828.2 1925.7
90.0 82.6 28.9 201.5
220.2 205.6 94.1 519.9
236.2 220.6 103.1 559.9
246.1 230.7 97.4 574.2
256.0 240.4 102.9 599.3
271.9 256.5 107.6 636.0
285.1 269.5 113.3 667.9
297.0 280.8 102.1 679.9
309.5 291.0 104.8 705.3
325.5 307.2 110.3 743.0
347 328.1 122.9 798.0
368.3 348.2 138.5 855.0
374.5 354.3 137.3 866.1
377.1 358.1 137.0 872.2
382.7 363.6 141.7 888.0
394.2 374.6 148.9 917.7
22.1 4.5 8.2 7.1 4.4 4.5 50.8
49.3 7.7 17.6 15.9 10.8 10.5 111.8
54.0 7.9 19.1 17.2 12.3 11.8 122.3
55.6 7.8 20.0 18.2 13.7 11.4 126.7
60.2 8.0 21.8 19.9 15.4 11.9 137.2
64.3 8.2 23.8 21.2 16.4 12.3 146.2
70.2 8.5 26.1 23.6 17.8 13.1 159.3
75.6 8.6 28.6 25.7 19.3 13.9 171.7
79.3 9.0 29.2 26.4 21.5 14.6 180.0
85.3 9.8 30.6 27.4 23.9 15.4 192.4
92.3 10.5 32.2 29 26.4 17.3 207.7
95.8 10.5 32.8 29.8 28.4 18 215.3
97.4 10.4 32.9 29.9 30.5 17.5 218.6
104.2 10.2 35.8 31.8 33.2 18.1 233.3
107.4 10.0 36.3 32.4 35.4 18.5 240.0
110.4 10.1 34.8 30.6 38.2 19.3 243.4
30.5 25.5 (NA) (NA) (NA) 56.0
90.1 80.4 (NA) (NA) (NA) 170.5
98.1 88.2 (NA) (NA) (NA) 186.3
104.6 95.1 (NA) (NA) (NA) 199.7
113.3 103.6 60.96 41.6 9.64 329.1
121.3 111.5 66.0 44.4 9.8 353.0
127.9 117.6 68.2 48.1 10.3 372.1
139.4 128.6 75.2 51.6 10.9 405.7
153.5 142.6 81.1 59.6 10.8 447.6
168 157.1 87.7 67 10.9 490.7
177.8 167.2 92.9 71.5 10.7 520.1
190.1 178.7 99.9 75.7 11.5 555.9
194.4 182.6 102.4 77.2 11.8 568.4
200.2 187.8 103.6 81.5 12.4 585.5
212.8 200.5 108.9 88.9 12.3 623.4
222.1 210.2 114.8 92.6 11.9 651.6
14.6 8.4 9.1 (NA) (NA) 32.1
31.0 16.9 22.8 (NA) (NA) 70.7
34.0 17.7 23.6 (NA) (NA) 75.3
36.4 18.1 23.8 (NA) (NA) 78.3
40.6 19.1 25.3 12.81 (NA) 97.8
44.0 18.3 27.8 15.0 16.8 121.9
47.0 19.5 28.3 15.8 16.8 127.4
50.5 19.9 30.3 17.2 14.1 132.0
54.1 19.8 35.9 20.8 14.5 145.1
57.8 19.6 40.5 23.9 14.8 156.6
63.3 20.1 43.6 26.2 14.7 167.9
70.6 21.7 45.6 26.6 15.6 180.1
75.5 22.5 49.1 30 14.6 191.7
77.8 21.7 55.2 35.5 14.2 204.4
79.7 21.6 60.6 40.5 15.0 217.4
82.0 22.1 68.7 46.3 15.9 235.0
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
*Note: From http://www.census.gov/econ/www/retmenu.html
540.7 77.1 56.5 10.7 685.0
1987
324.8 52.2 35.7 8.5 421.2
Source: U.S. Census Bureau, Current Business Reports, Annual Benchmark Report for Retail Trade, January 1990 Through December 1999, (BR/99-A) and prior issues.
498.1 71.2 50.8 10.5 630.6
1986
299.2 50.8 35.0 8.3 393.3
X Not applicable. NA Not available. \1 Based on 1987 Standard Industrial Classification code; see text, Section 13, Labor Force. \2 Includes kinds of business, not shown separately. \3 Excludes leased departments.
454.5 67.1 47.1 10.4 579.1
1985
114.8 18.1 11.3 3.0 147.2
Footnotes:
390.85 58.7 41.3 9.1 500.0
1984
781.9 886.7 110.7 125.2 83.1 94.6 13.1 13.8 988.8 1120.3
230.0 273.3 303.2 326.1 342.9 372.6 386 387.6 372.6 406.9 459.3 525.3 207.9 250.2 278.0 301.1 316.3 343.2 356.5 356.8 343 377.1 428.5 492.4 198.0 236.7 263.1 284.5 298.8 324.9 337.7 338.7 325.2 359.3 408.1 469.1 187.7 225.9 251.6 270.4 280.5 303.3 311.6 316 301.3 333.8 379.5 435.7 22.1 23.1 25.2 25.1 26.6 29.4 29.5 30.8 29.6 29.8 30.8 32.9 845.7 1009.2 1121.1 1207.2 1265.1 1373.4 1421.3 1429.9 1371.7 1506.9 1706.2 1955.4
Retail Trade Data: Outline By Applying Subtotals No. 1275. Retail Trade--Sales, by Kind of Business
Note: The data is now in Excel list format. That is, There's a header row. Each row is a record, or information about one entity. There are no blank [In billions of dollars (375.2 represents $375,200,000,000). Sales and inventories for leased departments columns or rows in the data. The data can be subtotalled, and concessions are tabulated in the kind-of-business category of the leased department or concession. and that automatically adds outlining and sub and grand Based on Current Business Survey, see Appendix III and summary below.] totals.
Business
Business Type 1970
New and used car dealers Durable goods stores, total \2 Floor covering stores Furniture stores Household appliance stores Motor vehicle dealers Nondurable goods stores, total \2 Radio, TV, and computer stores Refreshment places Restaurants, lunchrooms, cafeterias Women's clothing stores Appliance, radio, TV, & computer stores Auto and home supply stores Building materials, supply stores Catalog and mail-order houses Department stores \3 Drinking places Eating places \2 Family clothing stores Furniture, homefurnishings stores \2 Grocery stores Hardware stores Men's and boys' clothing stores Misc. general merchandise stores Motor vehicle, misc. automotive dealers Shoe stores Variety stores Women's clothing specialty stores Apparel and accessory stores \2 Automotive dealers Book stores Building materials and garden supplies \2 Drug stores and proprietary stores Eating and drinking places Food stores Fuel dealers Furniture and homefurnishings stores \2 Gasoline service stations General merchandise stores Jewelry stores Liquor stores Nonstore retailers Sporting goods and bicycle shops
Automotive Durables Household Household Household Automotive Nondurables Household Food Service Food Service Apparel Household Automotive Durables Specialty Nondurables Food Service Food Service Apparel Household Food Durables Apparel Nondurables Automotive Apparel Nondurables Apparel Apparel Automotive Leisure Durables Specialty Food Service Food Specialty Household Food Nondurables Leisure Specialty Specialty Leisure
54.3 114.8 (NA) (NA) (NA) 57.2 260.3 (NA) (NA) (NA) 7.1 5.6 6.0 11.3 (NA) (NA) (NA) 25.5 4.4 10.4 82.6 3.0 4.5 (NA) 59.2 4.5 6.1 8.2 22.1 65.2 (NA) 18.1 14.6 30.5 90.0 (NA) 17.0 28.9 49.1 (NA) 8.4 9.1 (NA)
1980 130.5 299.2 (NA) (NA) (NA) 137.7 658.1 (NA) (NA) (NA) 15.9 14.0 18.0 35.0 (NA) 85.5 (NA) 80.4 10.8 26.3 205.6 8.3 7.7 15.7 146.2 10.5 7.8 17.6 49.3 164.1 (NA) 50.8 31.0 90.1 220.2 (NA) 44.2 94.1 109.0 (NA) 16.9 22.8 (NA)
1981 144.5 324.8 (NA) (NA) (NA) 153.0 713.9 (NA) (NA) (NA) 17.2 15.4 19.6 35.7 (NA) (NA) (NA) 88.2 12.3 27.5 220.6 8.5 7.9 (NA) 162.3 11.8 8.2 19.1 54.0 181.9 (NA) 52.2 34.0 98.1 236.2 (NA) 46.9 103.1 120.4 (NA) 17.7 23.6 (NA)
1982 154.7 336.2 (NA) (NA) (NA) 162.9 733.2 (NA) (NA) (NA) 18.2 15.8 20.1 35.1 (NA) (NA) (NA) 95.1 13.7 27.1 230.7 8.7 7.8 (NA) 172.4 11.4 8.2 20.0 55.6 192.4 (NA) 51.0 36.4 104.6 246.1 (NA) 46.8 97.4 124.6 (NA) 18.1 23.8 (NA)
1983 187.7 390.85 (NA) 19.79 6.73 198.0 779.3 12.55 41.6 60.96 19.9 19.3 22.1 41.3 12.81 108.64 9.64 103.6 15.4 31.3 240.4 9.1 8.0 18.95 207.9 11.9 8.4 21.8 60.2 230.0 (NA) 58.7 40.6 113.3 256.0 (NA) 54.7 102.9 136.0 9.6 19.1 25.3 (NA)
1984 225.9 454.5 7.6 22.3 7.4 236.7 832.4 14.1 44.4 66.0 21.2 21.5 23.1 47.1 15.0 120.5 9.8 111.5 16.4 35.6 256.5 10.4 8.2 21.1 250.2 12.3 8.7 23.8 64.3 273.3 4.1 67.1 44.0 121.3 271.9 16.8 61.4 107.6 150.3 10.8 18.3 27.8 8.3
1985 251.6 498.1 7.9 23.9 8.4 263.1 876.9 16.7 48.1 68.2 23.6 25.1 25.2 50.8 15.8 126.4 10.3 117.6 17.8 38.3 269.5 10.5 8.5 23.8 278.0 13.1 8.5 26.1 70.2 303.2 4.5 71.2 47.0 127.9 285.1 16.8 68.3 113.3 158.6 11.2 19.5 28.3 8.7
1986 270.4 540.7 8.7 26.0 9.3 284.5 908.9 17.8 51.6 75.2 25.7 27.0 25.1 56.5 17.2 134.5 10.9 128.6 19.3 43.0 280.8 10.7 8.6 27.5 301.1 13.9 7.4 28.6 75.6 326.1 4.8 77.1 50.5 139.4 297.0 14.1 75.7 102.1 169.4 12.2 19.9 30.3 9.2
1987 280.5 575.9 9.9 26.7 8.6 298.8 965.4 18.5 59.6 81.1 26.4 27.1 26.6 61.3 20.8 144.0 10.8 142.6 21.5 44.5 291.0 11.0 9.0 30.8 316.3 14.6 7.1 29.2 79.3 342.9 5.3 83.5 54.1 153.5 309.5 14.5 78.1 104.8 182.0 12.9 19.8 35.9 11.3
1988 303.3 629.2 11.1 28.2 8.7 324.9 1027 21.9 67 87.7 27.4 30.6 29.4 66.8 23.9 151.5 10.9 157.1 23.9 47.6 307.2 11.9 9.8 33.5 343.2 15.4 7.5 30.6 85.3 372.6 6 91.1 57.8 168 325.5 14.8 85.4 110.3 192.5 14.3 19.6 40.5 12.8
1989 311.6 657.2 10.7 31.9 9.3 337.7 1101.8 23.4 71.5 92.9 29 32.7 29.5 67.5 26.2 160.5 10.7 167.2 26.4 51.2 328.1 12.6 10.5 37.8 356.5 17.3 7.9 32.2 92.3 386 6.5 92.4 63.3 177.8 347 14.7 91.3 122.9 206.3 14.4 20.1 43.6 14.2
1990 316 668.8 10.7 30.8 8.8 338.7 1175.8 24.3 75.7 99.9 29.8 33 30.8 70.3 26.6 165.8 11.5 178.7 28.4 50.5 348.2 12.5 10.5 41.4 356.8 18 8.3 32.8 95.8 387.6 7.4 94.6 70.6 190.1 368.3 15.6 91.5 138.5 215.5 15.2 21.7 45.6 15
1991 1992 1993 1994 301.3 333.8 379.5 435.7 650 703.6 781.9 886.7 10.1 10.4 10.8 11.7 30.2 31.2 32.8 34.8 8.3 8.4 9.1 9.0 325.2 359.3 408.1 469.1 1206 1,248.0 1,300.2 1,361.5 25.3 27.4 32.2 40.5 77.2 81.5 88.9 92.6 102.4 103.6 108.9 114.8 29.9 31.8 32.4 30.6 33.6 35.8 41.3 49.5 29.6 29.8 30.8 32.9 68.2 75.4 83.1 94.6 30 35.5 40.5 46.3 172.9 186.4 199.9 217.5 11.8 12.4 12.3 11.9 182.6 187.8 200.5 210.2 30.5 33.2 35.4 38.2 49.5 52.3 54.8 59.2 354.3 358.1 363.6 374.6 12.1 12.7 13.1 13.8 10.4 10.2 10.0 10.1 45.5 50.5 54.4 55.1 343 377.1 428.5 492.4 17.5 18.1 18.5 19.3 8.3 9.5 9.7 9.5 32.9 35.8 36.3 34.8 97.4 104.2 107.4 110.4 372.6 406.9 459.3 525.3 7.7 8.3 9.1 10.1 91.5 100.8 110.7 125.2 75.5 77.8 79.7 82.0 194.4 200.2 212.8 222.1 374.5 377.1 382.7 394.2 14.6 14.2 15.0 15.9 91.7 96.9 105.5 119.1 137.3 137.0 141.7 148.9 226.7 246.4 264.0 282.1 14.8 15.3 16.7 18.1 22.5 21.7 21.6 22.1 49.1 55.2 60.6 68.7 15.1 15.6 16.8 18.9
Retail Trade Data: Outlined Using Subtotals No. 1275. Retail Trade--Sales, by Kind of Business
Note: See the sample subtotal dialog at right. Sort before applying subtotals. Here, the data grouped using the "Business Type" field. [In billions of dollars (375.2 represents $375,200,000,000). Sales and inventories for leasedisdepartments are calculated for each year. and concessions are tabulated in the kind-of-business category of the leased department orSums concession. Based on Current Business Survey, see Appendix III and summary below.]
Business Women's clothing stores Family clothing stores Men's and boys' clothing stores Shoe stores Women's clothing specialty stores Apparel and accessory stores \2
Business Type 1970
Apparel 7.1 Apparel 4.4 Apparel 4.5 Apparel 4.5 Apparel 8.2 Apparel 22.1 Apparel Total 50.8 New and used car dealers Automotive 54.3 Motor vehicle dealers Automotive 57.2 Auto and home supply stores Automotive 6.0 Motor vehicle, misc. automotive dealers Automotive 59.2 Automotive dealers Automotive 65.2 Automotive Total 241.9 Durable goods stores, total \2 Durables 114.8 Building materials, supply stores Durables 11.3 Hardware stores Durables 3.0 Building materials and garden supplies \2 Durables 18.1 Durables Total 147.2 Grocery stores Food 82.6 Food stores Food 90.0 Gasoline service stations Food 28.9 Food Total 201.5 Refreshment places Food Service (NA) Restaurants, lunchrooms, cafeterias Food Service (NA) Drinking places Food Service (NA) Eating places \2 Food Service 25.5 Eating and drinking places Food Service 30.5 Food Service Total 56.0 Floor covering stores Household (NA) Furniture stores Household (NA) Household appliance stores Household (NA) Radio, TV, and computer stores Household (NA) Appliance, radio, TV, & computer stores Household 5.6 Furniture, homefurnishings stores \2 Household 10.4 Furniture and homefurnishings stores \2 Household 17.0 Household Total 33.0 Book stores Leisure (NA) Jewelry stores Leisure (NA) Sporting goods and bicycle shops Leisure (NA) Leisure Total 0 Nondurable goods stores, total \2 Nondurables 260.3 Department stores \3 Nondurables (NA) Misc. general merchandise stores Nondurables (NA) Variety stores Nondurables 6.1 General merchandise stores Nondurables 49.1 Nondurables Total 315.5 Catalog and mail-order houses Specialty (NA) Drug stores and proprietary stores Specialty 14.6 Fuel dealers Specialty (NA) Liquor stores Specialty 8.4 Nonstore retailers Specialty 9.1 Specialty Total 32.1 Grand Total 1078.0
1980 1981 1982 15.9 17.2 18.2 10.8 12.3 13.7 7.7 7.9 7.8 10.5 11.8 11.4 17.6 19.1 20.0 49.3 54.0 55.6 111.8 122.3 126.7 130.5 144.5 154.7 137.7 153.0 162.9 18.0 19.6 20.1 146.2 162.3 172.4 164.1 181.9 192.4 596.5 661.3 702.5 299.2 324.8 336.2 35.0 35.7 35.1 8.3 8.5 8.7 50.8 52.2 51.0 393.3 421.2 431.0 205.6 220.6 230.7 220.2 236.2 246.1 94.1 103.1 97.4 519.9 559.9 574.2 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 80.4 88.2 95.1 90.1 98.1 104.6 170.5 186.3 199.7 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 14.0 15.4 15.8 26.3 27.5 27.1 44.2 46.9 46.8 84.5 89.8 89.7 (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) (NA) 0 0 0 658.1 713.9 733.2 85.5 (NA) (NA) 15.7 (NA) (NA) 7.8 8.2 8.2 109.0 120.4 124.6 876.1 842.5 866.0 (NA) (NA) (NA) 31.0 34.0 36.4 (NA) (NA) (NA) 16.9 17.7 18.1 22.8 23.6 23.8 70.7 75.3 78.3 2823.3 2,958.6 3,068.1
1983 19.9 15.4 8.0 11.9 21.8 60.2 137.2 187.7 198.0 22.1 207.9 230.0 845.7 390.85 41.3 9.1 58.7 500.0 240.4 256.0 102.9 599.3 41.6 60.96 9.64 103.6 113.3 329.1 (NA) 19.79 6.73 12.55 19.3 31.3 54.7 144.3 (NA) 9.6 (NA) 9.6 779.3 108.64 18.95 8.4 136.0 1051.2 12.81 40.6 (NA) 19.1 25.3 97.8 3714.3
1984 21.2 16.4 8.2 12.3 23.8 64.3 146.2 225.9 236.7 23.1 250.2 273.3 1009.2 454.5 47.1 10.4 67.1 579.1 256.5 271.9 107.6 636.0 44.4 66.0 9.8 111.5 121.3 353.0 7.6 22.3 7.4 14.1 21.5 35.6 61.4 169.9 4.1 10.8 8.3 23.2 832.4 120.5 21.1 8.7 150.3 1133.0 15.0 44.0 16.8 18.3 27.8 121.9 4171.5
1985 23.6 17.8 8.5 13.1 26.1 70.2 159.3 251.6 263.1 25.2 278.0 303.2 1121.1 498.1 50.8 10.5 71.2 630.6 269.5 285.1 113.3 667.9 48.1 68.2 10.3 117.6 127.9 372.1 7.9 23.9 8.4 16.7 25.1 38.3 68.3 188.6 4.5 11.2 8.7 24.4 876.9 126.4 23.8 8.5 158.6 1194.2 15.8 47.0 16.8 19.5 28.3 127.4 4485.6
1986 25.7 19.3 8.6 13.9 28.6 75.6 171.7 270.4 284.5 25.1 301.1 326.1 1207.2 540.7 56.5 10.7 77.1 685.0 280.8 297.0 102.1 679.9 51.6 75.2 10.9 128.6 139.4 405.7 8.7 26.0 9.3 17.8 27.0 43.0 75.7 207.5 4.8 12.2 9.2 26.2 908.9 134.5 27.5 7.4 169.4 1247.7 17.2 50.5 14.1 19.9 30.3 132.0 4762.9
1987 26.4 21.5 9.0 14.6 29.2 79.3 180.0 280.5 298.8 26.6 316.3 342.9 1265.1 575.9 61.3 11.0 83.5 731.7 291.0 309.5 104.8 705.3 59.6 81.1 10.8 142.6 153.5 447.6 9.9 26.7 8.6 18.5 27.1 44.5 78.1 213.4 5.3 12.9 11.3 29.5 965.4 144.0 30.8 7.1 182.0 1329.3 20.8 54.1 14.5 19.8 35.9 145.1 5047.0
1988 27.4 23.9 9.8 15.4 30.6 85.3 192.4 303.3 324.9 29.4 343.2 372.6 1373.4 629.2 66.8 11.9 91.1 799 307.2 325.5 110.3 743 67 87.7 10.9 157.1 168 490.7 11.1 28.2 8.7 21.9 30.6 47.6 85.4 233.5 6 14.3 12.8 33.1 1027 151.5 33.5 7.5 192.5 1412 23.9 57.8 14.8 19.6 40.5 156.6 5433.7
1989 29 26.4 10.5 17.3 32.2 92.3 207.7 311.6 337.7 29.5 356.5 386 1421.3 657.2 67.5 12.6 92.4 829.7 328.1 347 122.9 798 71.5 92.9 10.7 167.2 177.8 520.1 10.7 31.9 9.3 23.4 32.7 51.2 91.3 250.5 6.5 14.4 14.2 35.1 1101.8 160.5 37.8 7.9 206.3 1514.3 26.2 63.3 14.7 20.1 43.6 167.9 5744.6
1990 29.8 28.4 10.5 18 32.8 95.8 215.3 316 338.7 30.8 356.8 387.6 1429.9 668.8 70.3 12.5 94.6 846.2 348.2 368.3 138.5 855 75.7 99.9 11.5 178.7 190.1 555.9 10.7 30.8 8.8 24.3 33 50.5 91.5 249.6 7.4 15.2 15 37.6 1175.8 165.8 41.4 8.3 215.5 1606.8 26.6 70.6 15.6 21.7 45.6 180.1 5976.4
1991 29.9 30.5 10.4 17.5 32.9 97.4 218.6 301.3 325.2 29.6 343 372.6 1371.7 650 68.2 12.1 91.5 821.8 354.3 374.5 137.3 866.1 77.2 102.4 11.8 182.6 194.4 568.4 10.1 30.2 8.3 25.3 33.6 49.5 91.7 248.7 7.7 14.8 15.1 37.6 1206 172.9 45.5 8.3 226.7 1659.4 30 75.5 14.6 22.5 49.1 191.7 5984
1992 31.8 33.2 10.2 18.1 35.8 104.2 233.3 333.8 359.3 29.8 377.1 406.9 1,506.9 703.6 75.4 12.7 100.8 892.5 358.1 377.1 137.0 872.2 81.5 103.6 12.4 187.8 200.2 585.5 10.4 31.2 8.4 27.4 35.8 52.3 96.9 262.4 8.3 15.3 15.6 39.2 1,248.0 186.4 50.5 9.5 246.4 1,740.8 35.5 77.8 14.2 21.7 55.2 204.4 6,337.2
1993 32.4 35.4 10.0 18.5 36.3 107.4 240.0 379.5 408.1 30.8 428.5 459.3 1,706.2 781.9 83.1 13.1 110.7 988.8 363.6 382.7 141.7 888.0 88.9 108.9 12.3 200.5 212.8 623.4 10.8 32.8 9.1 32.2 41.3 54.8 105.5 286.5 9.1 16.7 16.8 42.6 1,300.2 199.9 54.4 9.7 264.0 1,828.2 40.5 79.7 15.0 21.6 60.6 217.4 6,821.1
1994 30.6 38.2 10.1 19.3 34.8 110.4 243.4 435.7 469.1 32.9 492.4 525.3 1,955.4 886.7 94.6 13.8 125.2 1,120.3 374.6 394.2 148.9 917.7 92.6 114.8 11.9 210.2 222.1 651.6 11.7 34.8 9.0 40.5 49.5 59.2 119.1 323.8 10.1 18.1 18.9 47.1 1,361.5 217.5 55.1 9.5 282.1 1,925.7 46.3 82.0 15.9 22.1 68.7 235.0 7,420.0
An Agenda An agenda is the kind of hierarchical data that can make use of Excel's outlining mode. Since there are no calculations in this data, outlining must be applied manually.
Agenda Day 1 Dinner Opening Remarks Day 2 Breakfast Cocktails Opening Remarks Morning Address Morning Breakout Sessions Skiing Professionally Jean Claude Killy Martin Kennedy-Kilo Jaqueline Vitesse Opportunities with Beach Umbrellas Carribean Caspian Mediterranean Multi-Story Birdhouse Production A Bluebird Focus Grackle Retirement Communities Sparrow Getaways Lunch Vegetarian Vegan Ovo-Lacto Fruitarian Omnivorian Desertarian Afternoon Address Afternoon Breakout Sessions Financing Your Ski Career Moving Beyond Umbrellas Virtual Ornithological Housing Dinner Closing Remarks Condensed Expanded Day 3 Breakfast Departing Remarks
An Agenda Outlined Use the commands Data, Group and Outline, Groupto add outlining. Start by grouping the most detailed items first, then working out to the least detailed.
Agenda Day 1 Dinner Opening Remarks Day 2 Breakfast Cocktails Opening Remarks Morning Address Morning Breakout Sessions Skiing Professionally Jean Claude Killy Martin Kennedy-Kilo Jaqueline Vitesse Opportunities with Beach Umbrellas Carribean Caspian Mediterranean Multi-Story Birdhouse Production A Bluebird Focus Grackle Retirement Communities Sparrow Getaways Lunch Vegetarian Vegan Ovo-Lacto Fruitarian Omnivorian Desertarian Afternoon Address Afternoon Breakout Sessions Financing Your Ski Career Moving Beyond Umbrellas Virtual Ornithological Housing Dinner Closing Remarks Day 3 Breakfast Departing Remarks
Worksheet Views Your worksheet may have several layouts, each one useful. If you want to save each layout with a name so you can easily call it up, use a "View". To create a view 1. Establish the layout (and formatting) of the worksheet. 2. From the menus choose View, Custom Views. 3. Click the "Add" button to open the "Add View" dialog. 4. Give your view a name and click the "OK" button. Repeat to create any number of different views for a sheet. To see a view Choose View, Custom Views and select the layout you want from its name in the list. To delete a view Choose View, Custom Views, select the view to delete from the list, and click the "Delete" button.
Using Custom Views: Samples Choose View, Custom Views to see the two views established for this worksheet. Select either the "Basic Agenda" or the "Complete Agenda" from the list that displays.
Agenda Day 1 Day 2 Day 3 Breakfast Departing Remarks
Related Documents
Outlining And Grouping
November 2019 9
Note Taking And Outlining
November 2019 13
Basic Outlining
October 2019 17
019 - Grouping And Layering
November 2019 10
Grouping Seminar
June 2020 9