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.

Excel 2013 create pivot table