Excel – Keyboard shortcut in excel for expanding the pivot table row

keyboard shortcutsmicrosoft excelpivot table

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

Best Answer

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

Related Question