TOOLS MENU 

Sort 

The  Sort command is used when you want to sort a range of rows of the spreadsheet according to the 

contents of a specific column. 

If the option Show formulas is not selected (see p. 36) 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 that sorting the data in the spreadsheet is not required for any of the MedCalc statistical tests or 

procedures. 

Exclude   Include 

If you need to exclude data from statistical analysis, then you: 

  Select the data to exclude in the spreadsheet; the selection may either be a range of cells, or one or 

more complete rows (cases). 

 Select the Exclude command in the Tools menu. 

To include data that have been excluded, you:  

  Select the data to include in the spreadsheet; the selection may either be a range of cells, or one or 

more complete rows (cases). 

 Select the Include command in the Tools menu. 

Data that have been marked as excluded in the spreadsheet will be displayed in red, but you can select a 

different color in the Format Spreadsheet box (p. 35). 

The  Exclude and Include commands are also available in the spreadsheet shortcut menu (after right 

clicking). 

37