(To delete the row without deleting the child rows, remove the parent-child relationship first). You can’t delete a parent row without also deleting its indented child rows.When you click and drag a row that has items indented below it, the child rows will move with the selected item.You can continue indenting rows on your sheet to create multiple levels of hierarchy. Keep the following in mind as you work with hierarchy: To expand or collapse all sub-items on a sheet, right-click on the Primary Column header and select Expand All or Collapse All. To show or hide the indented items beneath a parent row, click expand/collapse / in the parent row’s Primary Column. That is, everyone who uses the sheet will see the same rows collapsed and expanded that you do. When you expand or collapse rows and then save the sheet, this changes the sheet structure for all collaborators shared to it. TIP: You can also use the keyboard shortcut Ctrl + [ or Command + [ on a Mac. To remove the parent-child relationship, click on a cell in the child row and then click the Outdent button on the toolbar. (More information on the Primary Column can be found here.) 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.
0 Comments
Leave a Reply. |
AuthorTrina ArchivesCategories |