Something changed. Previously you could Right-Click on a Pivot table and click E, C, or E, E to collapse/expand all - this is no longer the case.
Any other work around or fix in the near future?
Something changed. Previously you could Right-Click on a Pivot table and click E, C, or E, E to collapse/expand all - this is no longer the case.
Any other work around or fix in the near future?
E, Enter, E or E, Enter, C.
This is due to another shortcut with e being introduced in context menu (Show Details, which expands all level of grouping).
EDIT:
Alternately...
E, ->, E or E, ->, C
You can also add these function to Quick Access tool bar.
Last edited by CK76; 09-09-2019 at 01:02 PM. Reason: See Edit:
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
That seems to work! It'll take some getting used to for sure. Not sure why they would change that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks