Sort rows

Command:

Tools Sort rows

Description

Sorts a range of rows of the spreadsheet according to the contents of a specific column. The data can be sorted in ascending or descending order.

If the option Show formulas (View menu) is not selected then the spreadsheet is sorted according to the calculated values of the cells. If on the other hand the option Show formulas is selected then the literal content of the cell is used for sorting.

Note:

• Sorting the data in the spreadsheet is not required for any of the MedCalc statistical tests or procedures.
• The Sort rows command is only available when the MedCalc spreadsheet is open and active.

  See also

  • The spreadsheet data window