Sort, filter, and organize
Find what matters in a large table and arrange it your way.
Search, filter, and sort
The toolbar above the table has:
- Search to find rows containing a word.
- Filter to show only the rows that match your conditions. Combine several conditions, like "Risk level is High" and "Contract type is MSA".
- Sort to order rows by one or more columns.
- Row height to show more or less of each cell: Short, Medium, Tall, or Extra tall.
- Columns to show or hide columns.
To sort by a single column quickly, select its header and choose Sort.
Filters work best on select, number, and date columns. That's another reason to use the right column type.
Arrange columns
From a column's header you can:
- Pin it to the left or right, so it stays visible as you scroll.
- Hide it. Show it again from Columns in the toolbar.
- Insert a column to its left or right, Duplicate it, or Delete it.
To move a column, hover over its header and drag the grip that appears over the column's type icon. To resize a column, drag the edge of its header.
Sorting, filters, row height, column widths, and hidden or pinned columns only change your own view, and they're saved in this browser. Moving a column changes the table for everyone with access.
Undo
Press Cmd+Z (Mac) or Ctrl+Z (Windows) to undo your last change to the table, and Cmd+Shift+Z or Ctrl+Y to redo.
The table menu
Use the buttons at the top right of a table to Share it or pin it to your sidebar. Open the menu next to them to Rename the table, Add to project, or Delete it.