Expanding a Row

  • Updated

 

In Spreadsheet.com, expanding a row gives you a new 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.

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.

Expanded-Row-ID.jpg

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. 

Hidden columns are displayed in the expanded row.

Expanded-Row-ID-Top.jpg

The Row Number and Row Name are displayed at the top of the expanded row, with the row name coming from the designated primary column. Each column is then shown as a separate Editable Form Field with a Data Type Indicator and the Column Name. Column names are set via the table header row or the column header.

Attachment columns are displayed as clickable thumbnails. You can add new attachments via the add attachment link or reorder attachments using the drag selector mceclip0.png next to the attachment's name. Also, rename and delete attachments via the Edit file name mceclip1.png and Remove file mceclip2.png icons that appear when you mouse over the attachment's name. 

Expanded-Row-ID-Bottom.jpg

Related row 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.

Formulas columns are designated by a formula symbol next to their column name and cannot be edited in an expanded row. Formula cells show the calculated result rather than the formula itself.

In addition to Formula Columns, System Data Types like the Autonumber, Created by, and Updated at data types are not editable, either in the usual worksheet view or by expanding a row.

Expanded-Row-ID-Messages.jpg

Row Channel allows you to view and collaborate on cell and row-level comments (provided you have the necessary permissions). Use this space to @mention users to notify them of details in your worksheet, ask questions, or leave comments for others who view the worksheet.

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 mceclip0.png, and cell messages are designated with a yellow flag in a cell mceclip1.png.

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. Read on to learn about more unique row features like Row Hierarchies.