The spreadsheet data window

In MedCalc, data are entered in a spreadsheet. You can open a spreadsheet by selecting Spreadsheet in the View menu, or selecting Data in the Contents window.

The spreadsheet data window

One cell (rectangle) of the spreadsheet is highlighted. This rectangle is called the cell pointer.

The first character(s) of this cell address (A) is the column indicator and the next number is the row number (row 1 is the first row number). Above row 1, there is an additional fixed row where you can enter a column heading, i.e. a name for the variable for which data will be entered in this column.

The column and row of the cell pointer are also called the current column and row.

The cell pointer can be moved with the arrow and/or cursor keys, or by means of the mouse. When you click on a cell, the cell pointer jumps to this cell. You can browse in the spreadsheet window by clicking the right and bottom border of the spreadsheet window, or by using the Page Up and Page Down and other cursor or arrow keys.

By pressing the Ctrl+Home key you move the cell pointer to the first data cell in the spreadsheet: cell A1, and with Ctrl+End to the last cell used in the spreadsheet.

See Appendix A for an overview of control keys.

You can fix a number of columns in the spreadsheet by using the Split window command:

The spreadsheet data window


Total number of columns and rows in the spreadsheet

The number of columns is 16384 and the default number of rows is 30000. However, you can configure MedCalc to contain a lower or higher number of rows. The number of rows available in the spreadsheet can be set in the Options dialog box.


How to enter data

See also

Privacy & cookies Contact Site map