• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > PivotTable—Display and Hide Items

PivotTable—Display and Hide Items

PressTo
Alt+Down ArrowDisplay the drop-down list for a field in a PivotTable or Pivot-Chart report.
Use theArrow keys to select the field.
Up ArrowSelect the previous item in the list.
Down ArrowSelect the next item in the list.
Right ArrowFor an item that has lower-level items available, display the lower-level items.
Left ArrowFor an item that has lower-level items displayed, hide the lower-level items.
HomeSelect the first visible item in the list.
EndSelect the last visible item in the list.
EnterClose the list and display the selected items.
SpacebarCheck, double-check, or clear a check box in the list. Double-check selects both an item and all of its lower-level items.
TabSwitch among the list, the OK button, and the Cancel button.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint