data group

Both rows and columns of a worksheet can be outlined or grouped. Outlining provides a way to organize details. Outlines can be collapsed or expanded to hide or show detail within the data list. Once defined, the group of rows or columns can be ... expanded or collapsed to display or hid the detail contained within them. Follow the steps below to group rows or columns in a worksheet: Select the rows or columns to be grouped. Choose Data | Group and Outline | Group. To remove the grouping follow these steps: Select the rows or columns to be ungrouped. Choose Data | Group and Outline | Ungroup. ... (view more)