However, if there are groups nested within each other, the basic controls have numbered buttons so you can hide the different levels of nested groups. Go to Data > Group and Outline > Group on the menu bar, or press the F12 key.Ībove the grouped columns a control appears to show (+) or hide (-) the group. Select the rows or columns you want to group in your spreadsheet.Ģ. GroupingĬalc can organize data into groups, allowing you to easily show and hide different sections of your spreadsheet. The Subtotal command in Calc automatically creates groups and applies common functions like SUM to the grouped data. You can create an outline of your data and group rows or columns together so that you can collapse a group to hide it or expand a group to show it using a single click.
0 kommentar(er)
