- Image and text skills
The reports used at work always need to be changed into various formats, and they only use the default display method of pivot tables?
Why do other people's perspective tables look different from my own?
Let’s teach you how to quickly beautify the layout of a PivotTable.
■Place the mouse at (A6) and click on the upper menu bar-Design-Report Layout.
There are three layout methods:
"Compressed form" only occupies one column no matter how many row fields are superimposed.
"Outline" rows and columns appear side by side.
"Tabular" displays in tabular form.
And you can also freely select the appearance of the pivot table in the appearance box on the upper right.
In this way, your pivot table will no longer be boring~
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ju-tou-shi-biao-shi-li-yu-ying-yong-shu-ju-tou-shi-biao-de-san-zhong-bu-ju.html
评论列表(196条)
测试