According to the hierarchy of your fields, columns could be nested within columns which are higher in situation.
To rearrange fields, simply click the sphere name in among the spots, after which choose one of the following commands:
Be aware: Tables You should not guidance remaining to correct sorting. To take action, 1st transform the table to a range by picking out any cell during the desk and after that choosing Table Instruments > Change to vary. Choose any cell within the range you ought to kind.
As well as sorting ascending or descending, you may manually type Every on the row or column labels. Hover the cursor around the item's border until you see the shift cursor, then drag.
To rearrange fields, click on the field identify in one of many locations, after which pick out one of the subsequent instructions:
To keep associated knowledge from spreading horizontally off from the monitor and to assist decrease scrolling, click Exhibit in Compact Form.
Apply a type to format a PivotTable You could rapidly change the seem and structure of a PivotTable through the use of a single of various predefined PivotTable models (or fast designs).
知乎，让每一次点击都充满意义 —— 欢迎来到知乎，发现问题背后的世界。
Define sort is comparable to tabular sort but it surely can display subtotals at the highest of each get more info team for the reason that objects in the next column are displayed one particular row underneath the current product.
You'll be able to rearrange current fields or reposition People fields by using one of several 4 parts at The underside with the structure portion:
Unhide rows and columns prior to deciding to sort Concealed columns usually are not moved after you type columns, and concealed rows usually are not moved after you sort rows. Prior to deciding to kind data, It really is a good idea to unhide the hidden columns and check here rows.
If your supporting info is within an Excel Table, then the array will immediately resize as you add or get rid of info from your array array for anyone who is using Structured References. For additional information, see this information on Spilled Array Habits.
If you alter the structure with the PivotTable by filtering, hiding levels, collapsing and increasing ranges, or going a industry, the conditional structure is managed as long as being the fields within the fundamental facts are usually not removed.
知乎，让每一次点击都充满意义 —— 欢迎来到知乎，发现问题背后的世界。