File | Edit | View | Insert | Format | Tools | Data | Window |
This option is used to group the number of rows and columns. This will create + (expand)or - (collapse) signs on the left side of rows or top of the columns.
Grouping
-Select the row/columns to group.
-Data - Group and Outline - group.
-Select the option; Rows to group the rows or Column to group the column.
-Click on Ok.
-Select the row/columns to group.
-Data - Group and Outline - group.
-Select the option; Rows to group the rows or Column to group the column.
-Click on Ok.