Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Group

Defines the selected cell range as a group of rows or columns.

To access this command...

Choose Data - Group and Outline - Group.

F12

On Tools bar, click

Group

When you group a cell range, and outline icon appears in the margins next to the group. To hide or show the group, click the icon. To ungroup the selection, choose Data – Group and Outline - Ungroup.

Include

Rows

Groups the selected rows.

Columns

Groups the selected columns.

Grouping and ungrouping is not tracked. Group is greyed out when track changes is on.