Sort Rows

Key Features

• Multi-column sorting – Add multiple conditions to sort by several columns in order of priority (e.g., sort by Country, then by Date).
• Ascending or descending order – Choose the direction for each column independently.
• Type-aware sorting – Automatically detects and sorts numbers, dates, and text correctly.
• Row range selection – Limit sorting to a subset of rows by specifying start and end row indexes.
• Dynamic configuration – Add or remove sort conditions as needed for flexible ordering.

How to Use

1. Open the Sort Rows dialog.
2. Enter the column index you want to sort by.
3. Choose the direction (Ascending or Descending).
4. (Optional) Click Add Sort Condition to add additional columns for secondary sorting.
5. (Optional) Adjust the Start Row and End Row fields to limit sorting to part of the dataset.
6. Click Sort to apply, or Cancel to exit without changes.

Examples

Single-column: Sort by column 2 (numeric) in ascending order → values go from smallest to largest.

Multi-column: First sort by column 0 (Country), then by column 3 (Date) → groups rows by country, with dates sorted inside each group.

Partial range: Sort only rows 5–20 → the middle of the dataset is reordered, while rows above and below stay the same.