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.

Checked against the app 10 Nov 20262 min readSmart Tables

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

  1. Pick the column

    Click any cell in the column you want to sort by.

  2. 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

  1. Open the Table menu and choose Filter, or press Cmd+Shift+L on a Mac or Ctrl+Shift+L on Windows.

  2. A filter button appears in each column of the last heading row. In a table without heading rows, it appears in the first row.

  3. 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

  1. Select the cells

    Select the cells the rule should cover, such as a column of prices.

  2. Open conditional formatting

    Open the Table menu and choose Conditional Formatting…, then Add a rule for the selection.

  3. Set the rule

    Under Format cells if, choose a condition, such as Greater than, and enter a value.

  4. 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

Did this help?

Ask support
Step 1 of 6