Microsoft Office Tutorials and References
In Depth Information
Grouping and ungrouping worksheet rows
Grouping and ungrouping worksheet rows
As you develop worksheets, you’ll probably try to keep similar
entries together. For example, if you create a worksheet that
lists all the products you sell, you can group the products by
category. In the case of a garden supply store, all the tools
can be together, then the furniture, and then a new category
for each type of plant. You can always remove a group, or the
entire outline, when you no longer need it.
Group worksheet rows
1 Select the rows or columns that you want to group.
2 Click the Data tab.
3 In the Outline group on the ribbon, click Group.
1
2
3
Ungroup worksheet rows
1 Select the rows or columns that you want to ungroup.
2 Click the Data tab.
3 In the Outline group on the ribbon, click Ungroup.
2
3
1
Search JabSto ::




Custom Search