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

Spreadsheet

Command:View
Next selectSpreadsheet
Button:Toobar button

Description

Opens the MedCalc spreadsheet window, in which you can enter or edit data to be analyzed.

MedCalc spreadsheet window

The active cell in the spreadsheet is indicated by the cell pointer. The cell pointer can be moved to another cell by pressing the arrow or cursor keys (see Appendix: Control keys for an overview of control keys and special key functions).

When you want to put new data in a cell, move the cell pointer to the cell and enter the data on the keyboard.

To change the content of a cell, move the cell pointer to this cell and press function key F2. The cell content will be displayed at the top of the window. You can now change the cell, and edit the data. The Left arrow and Right arrow arrow keys can be used to move the cursor in the cell (just like editing a text in a word processor).

The Backspace key is used to delete the character at the left side of the cursor, and the Delete key deletes the character at the right side. If desired, you can erase the entire cell by pressing the Backspace key repeatedly.

Use the Insert key to toggle between Overwrite and Insert editing mode.

The new content of the cell is stored in memory by moving the cell pointer up or down. By pressing the Enter key you can store the new or edited contents of a cell without moving the cell pointer.

To copy the contents of one cell to another cell, place the cell pointer on the first cell (the source cell), and click Copy on the Edit menu (you can obtain a context menu by pressing the right side mouse button). By doing so, the content of this cell is copied into a buffer in memory. Now you move the cell pointer to the second cell (the target cell) and click Paste on the Edit menu. As a result, the content of the buffer is copied into this second cell.

If you want to copy a range of cells, you first select the cells with the mouse, and proceed as described above.

See also