Indenting rows not only visually tabs the row but also creates a group or hierarchy between rows. Use indented rows when you have rows that are connected to each other. For instance, sub-tasks to a master task in your team's project plan, budget line items that roll up to a budget group, or team structures showing who each team member reports up to. For more insight into how or why to use row hierarchies, see our article on article on Creating Row Hierarchies.
Topics in this Article:
About Row Hierarchies
In Spreadsheet.com, rows can be indented and thereby become "children" to their "parent" row. This indent ability has multiple names, including row hierarchies, "tabbing" or "indenting" rows, and grouping rows.
The top-level of a hierarchy is generally referred to as the "parent" row or a "Level 1" row. Rows one indent lower are known as the "child" or a "Level 2" row. Two indents in are "grand-child" or a "Level 3" rows, etc.
Hierarchies allow you to group rows together in parent or child relationships that can then be collapsed to ride the rows. Collapsing a row hides the entire row from view, and is visually set off by a plus sign to note that some child rows are collapsed. Deleting parent rows also deletes the children rows.
Hierarchies also change the way that your worksheet sorts data, with sorts only applying to the children within each parent row. That way different children do not get sorted between different parents.
To indent a row, you must have an editor role or higher. You can only indent entries in the primary column and cannot indent the first row.
How to Indent Rows
There are three ways to indent a row. Either via the Indent row button in the toolbar , by right-clicking on the row and selecting Indent row, or via the Indent row option in the Data menu. For instance, to indent using the toolbar button, first select the desired row, and then click the Indent row button in the toolbar.
The indent will appear in the primary column, but collapsing or expanding the row will hide or appear the entire row. You can change where the indent appears by changing the primary column.
How to Outdent Rows
Indented rows can be outdented to break their grouping or change the order of your hierarchy. Like with indenting, there are three ways to outdent rows. You can outdent a row by selecting the row and either use the Outdent row button in the toolbar, by right-clicking on the row and selecting Oudent row, or via the Outdent row option in the Data menu.
Indenting rows allows you to do more than simply add a tab. Indenting rows groups them together, allowing you to collapse and expand rows in hierarchies, to use special formulas, and change Kanban views. For complete details about Row Hierarchies, check out the article on Creating Row Hierarchies.