Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

Sort rows


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.

Sort rows

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.


  • 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