Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 3 down vote accepted

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

Edit: In case you don't have a menu/application key, you may be able to access the context menu by pressing Shift+F10

share|improve this answer
+1 for Shift+F10 tip – rishimaharaj Feb 25 '15 at 1:06

Menu Key, E E - expands all

Menu Key, E C - collapses all

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .