高頓網(wǎng)校友情提示，*7怒江傈傈族會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-透視表終曲_值字段技巧等內(nèi)容公布如下：
　　If you want to re-position the captions elsewhere, you can simply drag-and-drop the “∑ Values” field to another drop zone or another position in the drop zone that currently contains the “∑ Values” field. Say I wanted to see the labels above the “Year” field in the Column area. All I need to do is start dragging the “∑ Values” field, and I get feedback as to where the field will end up when I am done (blue bar, new cursor).
　　如果您想把標(biāo)題放到其它地方，您只需拖拽"∑ Values"字段到其它拖放區(qū)域或者已含有"∑ Values"字段的拖放區(qū)域的別的位置。也就是說當(dāng)我要查看列區(qū)域中"Year"字段上面的標(biāo)簽的時(shí)候，我所要做的就是拖動(dòng)"∑ Values"字段，當(dāng)我要放下（藍(lán)色邊，不一樣的鼠標(biāo)指針）的時(shí)候就會(huì)看見字段豎起來。
　　If I drag the “∑ Values” field above the “Year” field and let go, the PivotTable will refresh, and the captions will now be outside the year information, showing me a different view of my data. Here is what that looks like.
　　如果我將"∑ Values"字段拖到"Year"字段上放下，透視表就會(huì)刷新，并且標(biāo)題也會(huì)顯示出年度的信息，顯示出來的是一個(gè)不同的視圖。如下：
　　I can also move the captions to the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field to the bottom of the hierarchy on the Row area.
　　我也可以將標(biāo)題移動(dòng)到行上。下面是當(dāng)我移動(dòng)"∑ Values"字段到行的底端相應(yīng)級(jí)別時(shí)透視表的樣子：
　　Further, I can move the captions anywhere else in the hierarchy in the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field in between the Product Name and Product Category fields.
　　而且，我可以在行的同級(jí)別里隨意移動(dòng)標(biāo)題。下面是我將"∑ Values"字段移到Product Name 和Product Category字段中間的樣子：
　　By now you are probably getting the idea – the placement of the labels is infinitely flexible, allowing you to see the data pretty much any way you want. Hopefully folks see this as a useful feature. As always, I am interested to hear your feedback.
　　現(xiàn)在你應(yīng)該大概明白了——標(biāo)簽的位置已經(jīng)非常自由了，可以按照你希望的方式更精致的顯示數(shù)據(jù)。呵呵，這是一個(gè)非常有用的功能。
 　　　　
　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、?？迹瑢?duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。