Sort, filter and highlight table rows
Sort the rows of a Table content block, filter out rows your customer doesn't need to see, and colour cells by their values with conditional formatting.
Sorting and filtering are for you, the author. Your customer sees the table in the order you leave it, without the rows you filter out.
Sort rows
Sort by one column
2 steps
Pick the column
Click any cell in the column you want to sort by.
Sort
Open the Table menu and choose Sort A → Z or Sort Z → A.
Sorting moves the rows for good. Heading rows stay at the top. Formulas keep pointing at the same cells after a sort.
A table with cells merged across rows can't be sorted. Unmerge them first.
Filter rows
Open the Table menu and choose Filter, or press Cmd+Shift+L on a Mac or Ctrl+Shift+L on Windows.
A filter button appears in each column of the last heading row. In a table without heading rows, it appears in the first row.
Click a column's filter button. Choose the values to show, or filter by a condition, such as Greater than, or by colour. You can also sort from here.
Rows that don't match stay in the editor, shown faded. Your customer doesn't see them in the viewer or the PDF. The filter is saved with the table.
To show every row again, choose Clear Filters from the Table menu. To turn the filter buttons off, choose Remove Filter.
Highlight cells with conditional formatting
Colour cells by their value
4 steps
Select the cells
Select the cells the rule should cover, such as a column of prices.
Open conditional formatting
Open the Table menu and choose Conditional Formatting…, then Add a rule for the selection.
Set the rule
Under Format cells if, choose a condition, such as Greater than, and enter a value.
Choose the style
Choose bold, italic, underline or strikethrough, a text colour and a fill colour. Check the Preview, then choose Done.
You can also choose Color scale to shade cells from the lowest value to the highest.
When several rules cover the same cell, the one higher in the list wins. Use the arrows next to a rule to move it.
Rules can compare text, numbers and dates. Formulas can't be used in a rule.
Your customer sees the formatting in the viewer and the PDF.
Related guides
- Format table text and use keyboard shortcutsFormat part of a cell's text, fill cells by dragging, hide rows and columns, and move around a Table content block with Excel-style keys.Smart Tables
- Use formulas in a tableAdd up, multiply and compare values in a Table content block with spreadsheet formulas, format the results, and link to other tables, spreadsheets and pricing tables.Smart Tables