up vote 0 down vote favorite
share [g+] share [fb]

I'm able to expand/collapse the row in the pivot table with mouse by:

  • right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu.
  • or double clicking on the cell in the first column of the row

Is there a keybord shortcut for same action? I'm interested in Excel 2007 and 2010 shortcuts.

EDIT: updated excel versions

link|improve this question
50% accept rate
feedback

1 Answer

up vote -1 down vote

Once you click on the item that has lower level items available your right arrow expands the lower level items and your left arrow collapses the lower level items

link|improve this answer
Not sure what version you are using but right and left arrows simply do not expand or collapse PivotTable fields in any version I have (so that's 2000, 2003, 2007, 2010 Beta), they just move one cell in that direction. – AdamV Mar 25 '10 at 10:58
I had pulled it from a list of keyboard shortcuts in the Excel help files, but when I tried it after reading your comment you appear to be correct. Here is the quote from the Pivot Tables section of keyboard shortcuts. Maybe I misunderstood what they meant. To do this Press For an item that has lower-level items available, displays the lower-level items. RIGHT ARROW For an item that has lower-level items displayed, hides the lower-level items. LEFT ARROW – Jordan 1GT Mar 26 '10 at 2:15
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.