Tip Printed from ExcelTip.com

---

Adding Groups and Outlines Manually


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.