Rows are the core of any table. Learn how to add new ones, and select, expand, or delete existing ones.
If you're new to using tables in Superhuman Docs, this is a good place to start. Learn how to add new rows, select rows, and delete rows.
Add rows
Depending on the setup and customization of the table, the options for adding rows may vary. Here's a few different ways to add rows:
Hover over your table and click the + New row option below the bottom row
Hover between rows towards the left edge of the table, and click the + icon
Click on the bottom row of your table, then hit Enter on your keyboard
Click the +New button in the upper right corner of the table (this will also expand the row modal for easy adding - more on this below)
Build a custom canvas or column button that adds a row when clicked (more on this below)
FYI: When you add a row to a filtered view, fields will either be automatically pre-filled to match the filter criteria, or the row will be filtered out after editing.
Add rows in an expanded view
Most of the methods above add a new row directly into the table, where you can then fill in the necessary info. But two of the entry points - the +New button at the top of the table and custom buttons - actually can open the new row in an expanded view first, so you can fill it out before it's added.
The built-in +New button
In the upper-right corner of a table, the +New button can be shown or hidden from view via the table display settings. Once shown, you can customize the behavior of this button. Just right-click, then select Button options.
You can then customize the label, icon, and color of the button. You can also use the Open row for editing toggle to choose whether this button opens an expanded new row when clicked. By default, this toggle is set to on. Beneath this setting, you can choose how that expanded row appears: center, right, fullscreen, or form.
When you choose to open the new row as a form, this means you get access to all the useful capabilities of forms. You can set required fields, adjust the appearance of the form, and more. To set up this form exactly as desired, click Edit layout (while in the button options menu), then refer to this article for guidance.
Custom buttons
You can also create buttons - either on the canvas or as a table column - that add new rows when clicked. For the On click section of the button settings, just select Add row, then choose the target table. Choose whether to pre-fill any particular columns for the new row, and choose whether or not the row should be expanded for editing when the button is clicked (via the Open row for editing toggle).
Select rows
To select a row in a table, click the row handle that appears to the left of the row when you hover over it. Or, if you like keyboard shortcuts, click a cell and hit your keyboard's left arrow key to go all the way to the left, and it should highlight the entire row.
Once selected, you can right-click to move, duplicate, or delete the rows.
Copy and paste rows
Occasionally, you may need to copy and paste rows from one table to another. For instance, maybe you've decided that you no longer need two separate tables and you want to combine the rows into one table (then delete the other table).
💡 Keep in mind that copying rows as described here will create two totally separate copies of that data. Changes to one version will not impact changes to another. Therefore, we don't recommend copy and pasting rows in this manual fashion unless you are planning to delete one version or want two totally separate, disconnected versions of the data. If you want to have duplicate views of table data while keeping the data connected, consider creating a view instead.
To manually copy rows from one table to another, follow these steps:
First, make sure the columns of the source table match the columns of the destination table. This includes ensuring that the column order is the same.
-
Next, follow the instructions from the previous section to select the row or rows you wish to copy.
Note that when you select rows in this way (via the grab bars on the left), you are selecting the entire row, including the data in any hidden columns. If you wish instead to only copy the data in the visible columns, you can click and drag over the rows and columns that you want to copy until they are highlighted. Alternatively, you can click the upper-left-most cell, hold down the Cmd or Ctrl key, then click the lower-right-most cell.
Use the standard keyboard shortcut to copy your selection (Cmd+c on a Mac, Ctrl+c on a PC).
Next, go to the destination table and add a new row. With the left-most cell of this new row selected, use the standard keyboard shortcut to paste (Cmd+p on a Mac, Ctrl+p on a PC).
Expand rows
Sometimes you may want to see a row in its expanded view. For instance, maybe a row contains a lot of information and is hard to view within the setting of a full table. Expanding allows you to focus in on and see all the details of a specific row.
There are a few ways to expand a row, including:
Right-click a row and select Expand row
Use the Opt + Space keyboard shortcut
Hover over a row and click the expand icon (two opposing arrows) to the left of the row
Once the row is expanded, you can even choose where you want to see this expanded view. Click on the screen icon in the upper right corner of the expanded row, and choose either center (the default), right, or fullscreen from the options. Making this change will affect how you - and only you - view expanded rows from this table.
To customize how data is displayed within this expanded row view, check out this article on row layouts.
Delete rows
Once you've selected rows, you can delete them by simply clicking Delete on your keyboard. You can also delete one or more rows by using right-click to bring up the row menu and select Delete row everywhere.
FAQs
Is it possible to pin rows to the top of a table?
No, it isn't currently possible to pin or freeze rows. Column headers, however, will pin automatically as you scroll—no special steps necessary.
If you want to learn about freezing columns, check out this article.
How do I change the order of rows in a table?
If the table does not have any sorting rules applied (see below), you can manually reorder rows by simply dragging and dropping them into the correct position. To do so, click on the grab bar on the left edge of the row, drag it to the new position, and let go.
You can also change the order of rows by using the table's Sort feature. To learn more about sorting, check out this article.