In Spreadsheet.com, expanding a row gives users another way to access and edit the data in worksheets. Transforming a row's data from a Sheet or Kanban view to a form, expanded rows allow users with sufficient permission the ability to edit and collaborate. Clicking on related rows also expands the row in the related workbook, allowing you to edit one worksheet from inside another.
Expand a row when you want to see all of that row's data in one place, access the cell and row messages, or easily make edits to attachments and related rows. For instance, in your Simple Spreadsheet.com CRM, expand a row to make edits to an opportunity, see what other users are saying about that opportunity, or investigate the full details for the related customer.
How to Expand a Row
Users can expand each row to show all the data entered into the columns in that row as form fields that users can edit. Each expanded row also shows the row channel, which contains row and cell comments.
To expand a row, click on the expand icon in the row header.
You can also expand a row by double-clicking the row header or by right-clicking on the row header and selecting Expand row.
From the Kanban view, you can expand a row by clicking on the card.
Inside an Expanded Row
Expanding a row displays all of the cells in that row as a field in a form view. Expanding a row includes all cells, including ones that are not currently used. Based on your permission level, you can use the expanded row to edit cell values.
Note: Even hidden columns are displayed in the expanded row.
Row Number and Row Name are displayed at the top of the expanded row, with the row name coming from the designated primary column.
Related rows columns are displayed as cards. You can open or edit a related row by clicking on the card, which will cause that card to be expanded as a form you can edit. You can even preview and edit rows residing in a different workbook.
More about the Row Channel and Comments
Workbooks have three levels of channels: the workbook channel, row channels, and cell channels. Also called messages or comments, any user with sufficient permissions can leave a message in any of these three for other users to read. Comments in a row are designated by a yellow flag in the row header , and cell messages are designated with a yellow flag in a cell . When you expand a row, you will see both row and cell messages together in the Row Channel, sorted by when the latest comment was added. Responding to a cell message in an expanded row will add comments only to the row channel, not the cell channel. For complete details, see our articles on channels.
Expanding rows gives you access to several of Spreadsheet.com's unique features, including Related Rows and Row Channels. Check out the corresponding articles for those features or more unique row features like Row Hierarchies.