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.
Topics in this Article
- Row Basics
- The Table Header Row
- Expanding a Row
- Row Hierarchies
- Row Channel
- Related Rows
Like other spreadsheet software, 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. But we also cover a few particular features below.
Row Header and Selecting Rows
Each row number is shown on the far right side of your worksheet in the Row Header. In addition to row numbers, the row header will display a yellow dog-ear if there are comments in that row's channel, an expand row icon when you mouse over a row header, and row-specific options (like inserting rows, deleting rows, resizing rows, and more) when you right-click on a row header.
Selecting a row via the row header will select all cells in that row, allowing you to make changes across the whole row. Or click on a row header and drag up or down to select multiple rows.
Like traditional spreadsheets, Spreadsheet.com allows you to select contiguous populated rows with keyboard shortcuts in addition to clicking and dragging. 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.
There are two easy ways to resize rows:
- Select the row or rows to be resized, right-click on the row header, select Resize row, and specify the new row height.
- Or use the row boundary selector. Like with other spreadsheet software, you can select the desired rows to be resized and then manually drag the edge of one of the rows to adjust all selected rows' height, as shown below.
Similarly, Spreadsheet.com will automatically adjust selected row heights when you double-click on a row divider in the row header area, as shown below.
You can also use the row height selector in the view toolbar to adjust set rows in the worksheet to a fixed height. The Row Height feature is one of several Sheet view tools that you can use to customize your worksheet views.
Hiding Rows with Filters
There is not currently a right-click option to hide rows, as there is with columns. However, you can use filters to hide rows based on the data they contain. For example, you may want to filter out all completed tasks in a task management worksheet or all Closed Lost opportunities in your team's CRM.
To use a filter to hide a specific row, click on the filter button in the toolbar, click on + New filter , select a column, and customize your filter. For instance, in the animation below, we hide all rows except those with Beth or Roger's opportunities by filtering for Owner.
To unhide the row, change or delete the filter.
The Table Header Row
The table header row divides your worksheet into two regions — a header region and a table region — with the header region containing general or summary information about the worksheet plus the column header titles, and the table region containing data records.
By default, new worksheets do not have an assigned table header row, and every row in the worksheet is considered part of the table region. If you choose to set a row as a table header row (as in the example above) the column names will automatically adopt the names defined in your table header row cells.
Expanding a Row
When you hover over a row header with your mouse, or when one or more cells are selected in a row, you will see a blue 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 a row's form view, you can edit all data associated with that row and the changes are automatically applied in the row's cells.
The expand row feature is a great way to see and edit all the data associated with a record. Expanding a row also allows you to expand related rows and add or view all comments in cells for that row (we add a comment and @mention in the animation above).
For more details, see our article on expanding a row.
In Spreadsheet.com, rows can be indented and become "children" to a "parent" row, thereby setting up a hierarchy of rows. Creating row hierarchies allows you to collapse and expand rows, and is particularly useful in combination with Kanban views, where you can filter to show only the cards of a certain level in 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 indent button in the toolbar and that row will become the child of the one above it. Or reverse this with the outdent toolbar button.
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.
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 will show a yellow flag in the top right corner: . To view a row's messages, expand the row .
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 that live in different folders.
In the animation below, we are in our Applicant Tracker and add a new column to relate the Interview Tracker worksheet. We add a new column, edit the data type to Related Row, select the Interview Tracker worksheet in the Interview Tracker Workbook, and choose the row to relate (in our example, the relationship is based on the last name). If we were to make further changes here, they'd also appear in the "Interview Tracker" Worksheet.
For more articles on row features, check out our Row articles. Or dive into more detail about some of the unique row features mentioned above, such as the Table Header Row, Row Channel, and Row Hierarchies.