GROUPS

GROUPS

Formula Use & Explanation:

Groups are used to temporarly hide details and show only specific data.

Since Groups are used to temporarly hide data, unlike the hide command that completely hides

the rows and columns that we specifiy, groups enable us to view the details that we have hidden

immediately and do not require us to go through the lengthy process of using the unhide

command.

Example Used:

From the data below, only show the total no of employees but keep the rest of

the data available for viewing at any time.

GROUP STEPS IN DETAIL

STEP 1

• Select the first group of rows, as shown.

• Go to Data on the toolbar, then select Group & Outline, then select Group.

STEP 3

• Now repeat Step 2 for the rest of the Rows & Column’s, as shown circled in red.

STEP 4

• A completed set of groups will look like this, use the 1 2 3 buttons or the + signs to open and close the groups.