Introduction to Rows

  • Updated

Rows in Spreadsheet.com behave like those in traditional spreadsheets with powerful additional features like relationships, hierarchies, and table headers.

In Spreadsheet.com, rows behave as they do in traditional spreadsheets. You can apply the typical formatting, move rows, add rows, freeze rows, and more.

But rows in Spreasheet.com also have many new capabilities. They can be related across worksheets (even across folders and workspaces), displayed as cards in Kanban views, arranged in hierarchies, marked as a table header row to delineate header information and table data, and more.

For instance, if you have multiple separate worksheets—one for your HR team to use to track interview scheduling, another to track job postings, and a third to track candidates—you can relate all three so that individual rows are linked with related rows and populated with data from these related worksheets. Within a single row you can track a candidate's status in your Candidates worksheet, look up when her interview is scheduled from a related Interviews workbook, and look up details for the job she applied to from a Requisitions worksheet that lives somewhere else.

Row Basics

Similar to traditional spreadsheets, Spreadsheet.com has rows labeled in ascending sequential order. Cells in rows can be formatted however you like, and rows can be sorted and filtered to rearrange or hide rows. 

Unlike traditional spreadsheets, Spreadsheet.com also includes unique row functionality, including table header rows, the ability to expand a row to edit like a form, row hierarchies, row channels for messages about data in that row, and the ability to relate rows across worksheets and workbooks.

Spreadsheet.com allows you to insert rows, copy rows, freeze rows, delete rows, and merge rows. Most of these features have their own how-to articles, with complete explanations linked here. Let's explore some other basic row features below.

The Row Header

Each row number is shown on the far right side of your worksheet in the Row Header. Clicking on a row's header will select all cells in that row, allowing you to make changes across the whole row. 

Row-Header-ID.jpg

In addition to row numbers (1), the row header will indicate which row is the table header (2) and have a yellow dog-ear if there are comments in the row channel (3). When a row or cell in a row is selected, the row header will display an expand icon (4) that you can click to expand the row.

Right clicking on a row will open a dropdown menu with row-specific options like inserting a new row above or below, deleting or resizing the row, and more.

You can select multiple rows by clicking and dragging across contiguous rows or by using keyboard shortcuts. To do so, begin by selecting one or multiple contiguous rows. If you’re using a Mac computer, hold down Command and Shift on your keyboard and use the up or down arrow keys to select the contiguous populated rows. If you’re using a Windows computer, hold down Control and Shift on your keyboard and use the up or down arrow keys to select the contiguous populated rows.

Resizing Rows

To resize an individual row, right click on the row header and select "Resize row" from the dropdown menu. The Resize row dialog allows you to specify a row height in pixels or opt for the row height to dynamically adjust to its contents. Alternatively, you can resize a row by clicking the row header and vertically dragging its bottom boundary.

Want to quickly resize a row to dynamically adjust to the height of its contents? Select the row header and double click on the bottom boundary.

Spreadsheet.com also allows you to adjust the heights of all rows at once from the Sheet views menu bar above your worksheet.

Row-Heights-Locate.jpg

By default, the row height is set to "Flexible" and the height of each individual row will automatically adjust based on the text or other content within it.

Hiding Rows with Filters

Unlike columns, rows cannot be hidden on an individual basis. However, you can use filters to hide rows based on the data they contain. To access and manage your filters, click the Filters icon in the Sheet views menu bar above your worksheet.

Filter-Locate.jpg

From here, you can create, edit, and remove your worksheet's filters. For more information on working with filters, see our article on Filtering and Row Visibility.

The Table Header Row

When working with spreadsheets, you often add general information to worksheets above rows that are organized in table form. For instance, rows above this tabular region might contain information about a project name, owner, overall timeline, etc.

In Spreadsheet.com, you can explicitly mark a row as the table header row so that only rows below your header rows are treated as table records. The table header row is denoted by the table header icon mceclip1.png to the left of the row number. Everything below this row will be treated as table records, and everything above it will be ignored when performing actions like sorting and filtering or rendering records as Kanban view cards.

In any worksheet, you can set a row as the table header row by right-clicking on the desired row and selecting Set row as table header. From there, the table header row icon mceclip1.png will appear to the right of the row number.

Set-Table-Header.jpg

In the example shown above, Row 4 will become the table header row, and Rows 5 onwards will be considered table records.

For more information about table records and the Table Header Row, check out our suite of articles on Tables and the Table Header Row.

Expanding a Row

Expanding a row allows you to view and edit all of its records in a form view, as well as view associated messages and mentions. To expand a row, hover over the row number and click on the blue expand icon mceclip8.png that appears to the right of the row number.

Expanded-Row.jpg

The expand row feature is a great way to see and edit all the data associated with a record. Expanding a row can also allow you to expand related rows and see all comments in cells for that row.

Row Channel

In addition to adding messages to workbooks, users can add comments to cells or rows and @mention other users to send them a notification. The channel where all row and cell messages are displayed is known as the Row Channel. A channel is where all activity related to an entity is logged and displayed in reverse chronological order. The row channel can be viewed by expanding the row.

You can use the row channel to communicate with your team about the information in that specific row. The row channel also shows messages from all cell channels (message channels that belong to all the cells in that row). Rows with messages in them are indicated by a yellow flag in the top right corner of the row header: mceclip8.png.

Indenting Rows and Row Hierarchies

Spreadsheet.com allows you to create row hierarchies – "parent" and "child" relationships – by indenting rows. Setting up hierarchical relationships allows you to collapse rows and is especially useful in Kanban views, where you can filter to show only the cards of specific levels of the hierarchy. You can use indenting and outdenting to create row hierarchies for task lists, project plans, organization structures, and more.

To indent data in a row, select the indenting mceclip8.png button in the toolbar, and that row will become the child of the one above it, or perform the reverse with the outdenting mceclip9.png button in the toolbar.

Indent-Outdent-Buttons.jpg

For more information about creating and working with row hierarchies, see our article on Creating Row Hierarchies.

Related Rows

Related rows allow you to link to rows in other worksheets. Related rows work like tables in a relational database, where editing data in one changes the data in the other. You can create relationships with rows in any workbook you have access to, even workbooks in different folders.

For more information about working with Related rows, see our articles on all three Related row data types – Related Row, Related Row Lookup, and Related Row Rollup – or our suite of articles on relationships between worksheets.