技巧153 在受保护的工作表中调整分级显示视图

1月份2月份3月份一季度4月份5月份6月份沈阳5,19460,0983,17968,4712,3042,5483,700长春8,0001,2004,00013,2008003,6001,128黑龙江16,3245916,71223,6272,5907,6843,500东北小计29,51861,88913,891105,2985,69413,8328,328北京6,71630,1142,89739,72771,7832,01139,542石家庄3,8856,0796,36516,3294,5655713,399天津4,6003,0292,3009,9293,0232,3005,000华北小计15,20139,22211,56265,98579,3714,88247,941乌鲁木齐10,65036,3367,65854,644219,5735,233170,500西北小计10,65036,3367,65854,644219,5735,233170,500上海18,2548,4544,88731,5959,5234,8871,285苏州8,00024,0544,00036,05459,1424,00060,370南京2,3497886,2979,4345,5512,1245,402杭州25,230689,5356,707721,472304,8456,707304,845温州8,16060,2974,08072,53720,0992,95620,099华东小计61,993783,12825,971871,092399,16020,674392,001福州5,0113,3291,88710,2273581,0351,336桂林4,7673,5346678,9688892,8835,572广州6,3313,0622,18311,5763,8124,7902,689厦门1223,6443,0306,7964,9053,1313,283华南小计16,23113,5697,76737,5679,96411,83912,880成都5,2673766,36512,0085,7102,5365,190重庆3,9213,9671,6649,5525,5866,1022,466贵阳6,0933,57047510,1385,5137934,919西南小计15,2817,9138,50431,69816,8099,43112,575武汉4,8991,8043,1459,8486,4886,0524,341南昌4,6391,4711,7087,8186,0794,386549长沙8855,3273,3579,5695,0474,2721,048中部小计10,4238,6028,21027,23517,61414,7105,938总计159,297950,65983,5631,193,519748,18580,601650,163

二季度7月份8月份9月份三季度10月份11月份12月份8,5521,3571,9042,8276,0886,1822,0311,986 5,5283,1582,1334,2229,5132,4942,6536,651 13,7743,3074923,4957,2945,8574,8912,109 27,8547,8224,52910,54422,89514,5339,57510,746 113,3363,3254,8392,56810,7322,8474,766562 8,5353,0265,6304,22212,8781,7065,8264,162 10,3233,8642,1962,9398,9992,4402,9174,407 132,19410,21512,6659,72932,6096,99313,5099,131 395,3062,2701,521463,8373,1702,3581,785 395,3062,2701,521463,8373,1702,3581,785 15,6951046,7406,44913,2931,6742,887955 123,5123,0601413,8147,0151,1194,2072,416 13,0775,3593,1991,46410,0226,2122,3011,074 616,3972,1386,8171,41110,3664,7586,2835,674 43,1541,4262,0565,4358,9175,0059844,878 811,83512,08718,95318,57349,61318,76816,66214,997 2,7292,9424,6296,26613,8372,8333,0564,238 9,3446896,1384,85511,682544574,381 11,2914,1736,6324,30115,1065,5363,7554,819 11,3192,1152,2802,7047,0994,8685395,614 34,6839,91919,67918,12647,72413,2917,80719,052 13,4366,5205,3452,32714,1923,4139546,495 14,1543,9761,3434,74610,0654,6753,90731 11,2253,7851,6271,6397,0514,0485,010221 38,81514,2818,3158,71231,30812,1369,8716,747 16,8813,6711,4642,2517,3865,0205,193594 11,0143,9771,9331,8217,7313,3625,7033,561 10,3671,5083,8046,44911,7614,903732,995 38,2629,1567,20110,52126,87813,28510,9697,150 1,478,94965,75072,86376,251214,86482,17670,75169,608

四季度总计10,19993,310 11,79840,039 12,85757,552 34,854190,901

8,175171,970 11,69449,436

9,76439,015 29,633260,421

7,313461,100

5,51666,099

7,742174,323

9,58742,120 16,7151,364,950 10,867135,475 50,4271,782,967 10,12736,920

4,89234,886 14,11052,083 11,02136,235 40,150160,124 10,86250,498

8,61342,384

9,27937,693 28,754130,575 10,80744,922 12,62639,189

7,97139,668 31,404123,779 222,5356,219,734