Sort Sheet
Sort sheet rows by a 1-based column (optionally keep a header row).
ExcelExcelSort
What it does
Sort sheet rows by a 1-based column (optionally keep a header row).
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Excel instance | variable | Required | excel | Name that identifies this open workbook. |
| Sheet (blank = active) | string | Optional | Worksheet name; blank uses the active sheet. Supports variables | |
| Column (1-based) | number | Required | Example: 1 Supports variables | |
| Direction | dropdownAscending · Descending | Required | Ascending | |
| First row is header | dropdownYes · No | Required | Yes |
More Excel commands
Ready to automate your busywork?
Start your free 10-day trial today. No credit card, no commitment.