Excel shortcut to expand / collapse entire group outline level

keyboard shortcutsmicrosoft excelmicrosoft-excel-2019

I'm trying to find out if there's a shortcut key combination in Excel to expand & collapse an entire group outline level. This would be the the equivalent of mouse clicking on the 1, 2, 3, … buttons in the top left of the window:

Group outline level buttons in Excel

I know you can expand collapse individual sections using ALT + a + j / ALT + a + h, but I have some spreadsheets with many grouped sections and often find myself wanting to collapse all of them to a given level. Ideally that wouldn't involve me reaching over to my mouse…

I've Googled this extensively but it's either not out there or beyond my Googling skills

Best Answer

The only way I can think of, is using Ctrl + A, followed by

ALT + A + J / ALT + A + H

You could also record these actions as a macro and assign a keyboard short cut to the macro