Quick Start: Rows

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.

Traditional Spreadsheet Features: Insert, Copy, Delete, and Freeze Rows

If you've worked with traditional spreadsheets before, rows in Spreadsheet.com will be familiar. Rows are ordered numerically from top to bottom and can be augmented with text and cell formatting. You can manage and order your rows by inserting them, copying them, deleting them, reordering them, freezing them, and more.

Let's run through traditional row actions in Spreadsheet.com:

Inserting a Row

To insert a row, right-click on a row and select "Insert 1 row above" or "Insert 1 row below" from the dropdown.

Insert-Row-Dropdown.jpg

Or, click on a row or cell, select Insert from the top menu bar, and select one of the insert options from the dropdown.

Insert-Row-Menu-Bar.jpg

By selecting multiple rows at once, you can insert as many new rows as you have selected. To do so, select your desired number of new rows and follow either of the steps described above.

Copying Rows

Similarly, you can copy and paste rows from one worksheet or one place in your worksheet to another. To do so, select the row to be copied, right-click, and select "Copy" from the dropdown. Then, select the blank row, right-click, and select "Paste" from the dropdown. You can also use the Command-C and Command-V keyboard shortcuts.

Copy-Paste-Row.gif

You can also paste a copied row into a row that already has data in it, but note that doing so will overwrite the existing data.

Deleting Rows

Sometimes you need to remove a row from your worksheet. To do so, select the row to be deleted, right-click, and select "Delete row #" from the dropdown.

Delete-Row.jpg

If you want to delete the data from a row but retain the row itself, select the row and press the "Delete" key on your keyboard.

Freezing Rows

Freezing a row will ensure that all rows above the frozen row stay on your screen even as you scroll down. By selecting a row, right-clicking, and selecting "Freeze row" from the dropdown, all rows up to and including the selected row will be frozen as you scroll. To unfreeze the row, select it, right-click it, and select "Unfreeze" from the dropdown.

Freeze-Row-Dropdown.jpg

You can also freeze and unfreeze rows from the View menu in the top menu bar.

Freeze-View-Menu.jpg

Unique Spreadsheet.com Features

Spreadsheet.com has a host of new tools and tricks, like data types, views, and lookups to related worksheets. A few of these features are specific to rows, including the table header row, expanding a row, comments in rows, related rows, indenting rows, and row height below.

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.

Comments and @Mentions in Cells and Rows

In addition to adding messages to workbooks, users can add comments to cells or rows and @mention other users to send them a notification. Cells and rows with messages in them will show a yellow flag in the top right corner, like this: mceclip0.png. To see the messages in a cell, select the cell, right-click it, and select Cell messages from the dropdown.

To see all cell messages, and row-wide messages, expand the row.

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.

We'll explore Related rows further later in our Quick Start series. For a brief introduction, check out the video below:

Looking for a deeper dive into Related rows? Check out our suite of articles all about Related rows.

Indenting Rows to Create 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.

We'll explore row hierarchies later in our Quick Start series. For a brief introduction, check out the video below:

To indent data in a row, select the indent 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

Row Height

You can adjust the height of any individual row by clicking and dragging its bottom border from the row numbers section. 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-Button.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.

Recap: The Table Header Row

We've explored the table header row previously in our Quick Start series. To recap:

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.

For a deeper dive into working with table records and the table header row, check out our suite of articles on Tables and the Table Header Row.

In the next part of our Quick Start series, learn about working with different types of views ➡️.