» Adding Groups and Outlines Manually

CATEGORY - Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

To add groups and outlines manually:

1. Select cells to group (cells A2:A4 in the screenshot).
2. Press Alt+Shift+Right Arrow.
OR
From the Data menu, select Group and Outline, and then Group.
3. Repeat this technique for each group.
4. To clear the outlining, select the same rows or columns, and press Alt+Shift+Left Arrow.
Screenshot // Adding Groups and Outlines Manually