Indents are displayed only in a sheet's Primary Column however, the relationship is applied to the entire row. TIP: You can also use the keyboard shortcut Ctrl + ] or Command + ] on a Mac. Make sure neither row is blank before indenting. NOTE: If the Indent button is unavailable, you may be trying to indent a blank row. In order to create hierarchy, data needs to exist in both the parent, and child rows. The row above it will become the parent row. Note that hierarchy creates relationships between rows, it doesn't control row formatting.Ĭlick on a cell in the first row you’d like to indent, and then click the Indent button on the toolbar. It is not created by designating a row as a parent.
NOTE: Hierarchy is created from the child row. When you indent a row, it becomes a child of the row above it (the parent row). You can create a hierarchy on your sheet by indenting rows.
