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:
Edit: In case you don't have a menu/application key, you may be able to access the context menu by pressing Shift+F10