articles

Home / DeveloperSection / Articles / Keys for adding fields and totals and changing the layout of a PivotTable view

Keys for adding fields and totals and changing the layout of a PivotTable view

Vijay Shukla3066 04-Apr-2013
Keys for working with the field list
Key
Description

CTRL+L

Display the field list, or activate it if it's already displayed

Arrow keys

Move to the next item in the field list

SHIFT+UP ARROW

Move to the previous item and include it in the selection

SHIFT+DOWN ARROW

Move to the next item and include it in the selection

CTRL+UP ARROW

Move to the previous item, but don't include the item in the selection

CTRL+DOWN ARROW

Move to the next item, but don't include the item in the selection

CTRL+SPACEBAR

Remove the item from the selection, if the item that has focus is included in the selection, and vice versa

PLUS SIGN (numeric keypad)

Expand the current item in the field list to display its contents. Or expand Totals to display the available total fields.

MINUS SIGN (numeric keypad)

Collapse the current item in the field list to hide its contents. Or collapse Totals to hide the available total fields.

 

The TAB key

Alternately move to the most recently selected item, the Add to button, and the list next to the Add to button in the field list

ALT+DOWN ARROW

Open the drop-down list next to the Add to button in the field list. Use the arrow keys to move to the next item in the list, and then press ENTER to select an item.

 

ENTER

Add the highlighted field in the field list to the area in the PivotTable view that's displayed in the Add to list

ALT+F4

Close the field list

Keys for adding fields and totals
Key
Description

CTRL+SHIFT+S  

 

Add a new total field for the selected field in the PivotTable view by using the Sum summary function

CTRL+SHIFT+C  

 

Add a new total field for the selected field in the PivotTable view by using the Count summary function

CTRL+SHIFT+M

 

                Add a new total field for the selected field in the PivotTable view by using the Min summary function

CTRL+SHIFT+X  

 

Add a new total field for the selected field in the PivotTable view by using the Max summary function

CTRL+SHIFT+E  

 

Add a new total field for the selected field in the PivotTable view by using the Average summary function

CTRL+SHIFT+D  

 

Add a new total field for the selected field in the PivotTable view by using the Standard Deviation summary function

CTRL+SHIFT+T  

Add a new total field for the selected field in the PivotTable view by using the Standard Deviation Population summary function

CTRL+SHIFT+V  

Add a new total field for the selected field in the PivotTable view by using the Variance summary function

CTRL+SHIFT+R  

Add a new total field for the selected field in the PivotTable view by using the Variance Population summary function

CTRL+SHIFT+B  

Turn subtotals and grand totals on or off for the selected field in the PivotTable view

CTRL+F

Add a calculated detail field

Keys for changing the layout
Key
Description

CTRL+1

Move the selected field in the PivotTable view to the row area

CTRL+2

Move the selected field in the PivotTable view to the column area

CTRL+3

Move the selected field in the PivotTable view to the filter area

CTRL+4

Move the selected field in the PivotTable view to the detail area

CTRL+LEFT ARROW

Move the selected row or column field in the PivotTable view to a higher level

CTRL+RIGHT ARROW

Move the selected row or column field in the PivotTable view to a lower level


Updated 29-Nov-2017

Leave Comment

Comments

Liked By