Sorting
Column sorting brings the rows that matter to the top without changing the source data. Enable it for readers, then set a saved starting order for the table whenever you need one.
DISPLAY
Set a meaningful order
Enable sorting once, choose one or more priorities, then save the order you want readers to start with.
Enable sorting
Open macro settings, go to Display, and turn on Sorting. Sortable columns then show a sort control in their header.
Sort one column
- 1 Click the sort control for a column.
- 2 Click again to switch between ascending and descending order.
- 3 Click a third time to remove sorting for that column.
Add secondary priorities
Hold Shift and click the sort control for another column. The small number in the control shows its priority. The first column decides first; later columns order only the rows that share the preceding value.
Set the starting order
Make the sorting change in macro settings and save the macro. That configuration is applied when the table loads. Changes made by readers in a published table remain in their current view.
Example: prioritize support tickets
Multiple sort priorities make a large worklist immediately actionable.
- 1. Priority descending
- Critical and high-priority tickets come before normal tickets.
- 2. Created date ascending
- For the same priority, the oldest requests come first.
- Result
- The team starts with the most urgent, longest-open work.