Excel for mac group outline summary below detail

broken image

To Ungroup, you can use the keyboard shortcut Shift+ Alt+ ⇦ (Left Arrow Key). Use the keyboard shortcut Shift+ Alt+ ⇨ (Right Arrow Key) to Group rows more quickly, especially if you need to create multiple groups of rows. Step 3: Check or Uncheck the 'Show outline symbols if an outline is applied' How to Group Rows Using a Keyboard Shortcut Step 2: Scroll down to the 'Display Options for This Worksheet'

broken image

To hide/show outline symbols in a specific worksheet, follow these steps:

broken image

If for some reason the outline symbols do not show up when you use this feature, your worksheet may have the symbols hidden via the worksheet settings. Step 1: Select the rows that you want to hide when the button is clicked.

broken image