The drop-down contains the commands: Calculated Field, Calculated Item, Solve Order, List Formulas, Create Set Based on Row Items, Create Set Based on Column Items and Manage Sets. Move Pivot Table - Displays the 'Move PivotTable' dialog box.įields, Items & Sets - (Added in 2010). The drop-down contains the commands: Labels and Values, Labels, Values, Entire PivotTable, Enable Selection. The drop-down contains the commands: Clear All, Clear Filters. The drop-down also contains the Connection Properties command.Ĭlear - Drop-Down. The button displays the Change PivotTable Data Source lets you change the source data for this PivotTable. Connection Properties.Ĭhange Data Source - Button with Drop-Down. Refresh - update all the information in this workbook that is coming from external data sources. In Excel 2013 this command is accessible from the shortcut menu. Sorts the current selection so the largest items are at the top. Sort Largest to Smallest - (Removed in 2013).

Sorts the current selection so the smallest items are at the top. Sort Smallest to Largest - (Removed in 2013). Manage which filters the pivot table is connected to. Allows you to quickly filter your dates and choose specific time periods.įilter Connections - (Added in 2013). Displays the 'Insert Slicers' dialog box allowing you to quickly filter data. Group Field - Groups numeric or date fields. Ungroups a range of cells that are currently grouped. Ungroup Selection - (Shift + Alt + Left). Group Selection - Creates a group containing the currently selected items.

(Expand Entire Field in 2010).Ĭollapse Field - Collapses all items of the active field. The drop-down contains the commands:Įxpand Field - Expands all items of the active field.

The drop-down contains the commands:ĭrill Up - (Added in 2013). The whole group also appears on the Pivot Chart Tools Analyze TabĪctive Field - The name of the active field.įield Settings - Displays the 'Value Field Settings' dialog box.ĭrill Down - (Added in 2013). The drop-down contains the commands: Options which display Options dialog box, Show Report Filter Pages, Generate GetPivotData. The button displays the 'PivotTable Options' dialog box, Layout & Format tab. PivotTable Name - The name given to this Pivot Table.

2010 excel pivot table tutorial