知乎，让每一次点击都充满意义 —— 欢迎来到知乎，发现问题背后的世界。
There may be times when your PivotTable info is made up of blank cells, blank traces, or errors, and you should change the way They're displayed.
Observe: Tables You should not support left to appropriate sorting. To take action, initial change the desk to a spread by deciding on any mobile inside the table and after that deciding on Desk Resources > Convert to assortment. Decide on any mobile within the assortment you would like to sort.
Suggestion: When you check in to a public Pc, make certain to indicator out before you leave the computer. Learn how to sign in on a device that is not yours.
To discard the PivotTable format and format and resort towards the default format and structure every time which you carry out an Procedure to the PivotTable, very clear the Preserve cell formatting on update Check out box.
Whenever you add two or maybe more fields towards the Values space, whether they are copies of a similar discipline or unique fields, the sphere Checklist instantly provides a Values Column label towards the Values spot.
To discard the PivotTable format and format and vacation resort to the default structure and format each time that you perform an operation on the PivotTable, clear the Protect mobile formatting on update Check out box.
Make use of the regions segment (at the bottom) of the Field Record to rearrange fields just how you desire by dragging them in between the four spots.
Use the spots portion (at The underside) of the sphere Listing to rearrange fields the best way you want by dragging them involving the 4 parts. Fields which you place in numerous places are proven from the check here PivotTable as follows: Filters spot fields are demonstrated as major-amount report filters over the PivotTable, similar to this:
A column-oriented array or vary which contains the values which are used to team rows and make row headers. The array or array could include many columns. If so, the output should have many row team amounts.
To point out merchandise with no info on rows, pick out or very clear the Exhibit products with no data on rows Verify box to display or conceal row merchandise that have no values.
To alter the display of vacant cells, pick the For empty cells display check box, and then type the worth that you want to display in vacant cells while in the textual content box.
You are able to rearrange current fields or reposition Individuals fields by utilizing one of the 4 areas at the bottom of your format segment:
Develop and Collapse buttons are displayed so that you could display or hide click here particulars in compact sort. Compact sort is saves Place and makes the PivotTable far more readable and is particularly therefore specified as being the default structure type for PivotTables.