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


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


Menu Key, E E - expands all

Menu Key, E C - collapses all


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

  • 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



Menu - E

Hit the menu button on your keyboard followed by "e" on your keyboard.

  • 1
    This answer is exactly the same as the answer that has already been accepted. Can you clarify how your answer adds to the conversation or provides information not already here? – music2myear Jan 24 '17 at 19:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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