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
- Unique Spreadsheet.com Features
Traditional Spreadsheet Features
Spreadsheet.com looks and feels like any other spreadsheet, but with some added row features noted below. By default rows are numbered 1, 2, 3,... in descending order, and can be formatted in the usual ways (bold, cell fill color, alignment, borders, text wrapping, etc.).
Additionally, you can insert rows, copy rows, delete rows, reorder rows, freeze rows, and more as detailed below and in our set of row articles.
Inserting a Row
To insert a row, either:
a) right-click on a row and choose to add a row above or beneath it:
or b) click on a cell, then navigate to the Insert menu and insert a row above or beneath your selected cell:
Similarly, you can copy and paste rows from one worksheet or one place in your worksheet to another. In the animation below we copy a row, paste the previous row into where we've already inserted a row.
Sometimes you may need to remove a row. Like in the animation above, we've copy and pasted identical rows, so have two a duplicate and can delete one row.
Freezing a row will ensure that all rows above that row stay on your screen even as you scroll down. In the animation below, we set freeze everything above the table header row (including the table header row) by right-clicking and selecting Freeze row and Unfreeze the same way.
You can also freeze a row or rows in the View menu.
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.
The Table Header Row
When working with spreadsheets, we often add general information to spreadsheets above our tables. For instance, the title, author, and creation date of the table, key assumptions, or even a summary table of the data below. With the table header row, you can explicitly indicate that some rows are to be in this header region, and that a row other than the first is to dictate the names of columns. Rows above with table header row will be in the header region. Rows below the table header row will be in the table region and will be treated as table records (i.e., subject to sorting and filtering, rendering as cards in Kanban, etc.).
In the animation below we select a row to be our table header row, right-click and set it. Then, whenever we create a new view that header and data are replicated in the new view.
Expanding a Row
When you hover over a row with your mouse, or when one or more cells are selected in a row, you will see a green expand icon to the right of the row # in the row header. Clicking on a row's expand icon, or double-clicking the row header, opens the row in a form view. In the expanded row form view, you can edit all data associated with that row, add comments, @mention users, and more.
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: . To see the messages in a cell, simply right-click and select Cell messages. To see all cell messages, and row-wide messages, expand the row .
Alerts and Reminders in Rows
Soon Spreadsheet.com users will also be able to set alerts and reminders for individual rows. With alerts and reminders, users can track updates to important data, be notified when dependencies change, or set a reminder to themself so they don't forget to make a needed change to a worksheet.
Related rows allow you to link to rows in other worksheets. Related rows work like tables in a relational database, 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.
In the animation below we have two workbooks, one for applicant tracking and one for interview tracking. We'd like to relate the two, so add a new column for "Interview Tracking" and relate the matching row (for candidate "Baker"). Once the rows are related, we then add a column for the interview date and populate that with the data from the related row. If we were to make further changes here, they'd also appear in the "Interview Tracker" Worksheet.
Indenting Rows to Create Hierarchies
In Spreadsheet.com, rows can be indented and thereby become "children" to their "parent" row. Setting up such relationships allows you to collapse rows, and is especially useful in Kanban views, where you can filter to show only the cards of parents, children, grandchildren, etc. 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 button in the toolbar, and that row will become the child of the one above it. Or reverse this with the outdenting button in the toolbar. For more details on indenting and outdenting, see our Quick Start Guide on Indenting Rows to Create Hierarchies.
Not only can you adjust the row height of individual rows, but with the Row Height feature in the toolbar you can quickly adjust the heights of all rows. Especially useful when you add attachments, multiselect lists, and other data types, the Row Height feature is one of a few Sheet view tools that can be used to customize your worksheet.