Create a PivotTable to analyze worksheet data - Microsoft Support
Select a table or range of data in your sheet and select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a …
Sort data in a PivotTable - Microsoft Support
Set custom sort options. To sort specific items manually or change the sort order, you can set your own sort options. Click a field in the row or column you want to sort. Click the arrow next …
Set PivotTable default layout options - Microsoft Support
Set PivotTable default options, so your PivotTables start the way you want every time
Expand, collapse, or show details in a PivotTable or PivotChart ...
Showing or hiding details is supported for PivotTables created from a table or range. Show value field details. In a PivotTable, do one of the following: Click anywhere in the PivotTable. On the …
Filter data in a PivotTable - Microsoft Support
By using a report filter, you can quickly display a different set of values in the PivotTable. Items you select in the filter are displayed in the PivotTable, and items that are not selected will be …
Group or ungroup data in a PivotTable - Microsoft Support
With time grouping, relationships across time-related fields are automatically detected and grouped together when you add rows of time fields to your PivotTables. Once grouped …
Consolidate multiple worksheets into one PivotTable in Excel
Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can …
Design the layout and format of a PivotTable - Microsoft Support
To see all data in a traditional table format and to easily copy cells to another worksheet, select Show in Tabular Form. Change the field arrangement in a PivotTable To get the final layout …
Show or hide subtotals and totals in a PivotTable - Microsoft …
Create a PivotTable to analyze data in multiple tables. Filter data in a PivotTable. Calculate a percentage for subtotals in a PivotTable. Sum values in a PivotTable
Subtotal and total fields in a PivotTable - Microsoft Support
In a PivotTable, select an item of a row or column field. Make sure it is a field and not a value. On the PivotTable Analyze tab, in the Active Field group, click Field Settings.. This displays the …