Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

3 Answers 3

You can usually access the context menu through the right mouse button or by pressing the menu/application key. The menu key is between between the right Control and Windows keys. In Excel 2010 you should be able to:

  • Expand by selecting the cell, then pressing Menu, E, X
  • Collapse by selecting the cell, then pressing Menu, E, O
share|improve this answer

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

share|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

For Excel 2007 you can try with:

ALT + JT + X to expand the field
ALT + JT + P to collapse the field

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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