6/14/2023 0 Comments Pivot table tool analyzerIn 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.
0 Comments
Leave a Reply. |