Paste 

Button: 

Shortcut: Ctrl+V 

The Paste command is used to paste the contents of the clipboard onto the active window.   

If the Cut Copy Paste commands are used to move of copy a range of spreadsheet cells, then choosing 

this command pastes the contents of copied or cut cells into the area indicated by the cell pointer where 

the cell pointer is the upper left corner of the paste area. 

The Paste command can also be used to transfer data from Excel to MedCalc.  First activate Excel and 

select the range of cells you want to transfer, followed by selecting the Copy command.  Next activate 

MedCalc, open the spreadsheet window, position the cell pointer on the target location and select Paste in 

the Edit menu. 

Delete 

Shortcut: Del 

With the Delete command you can clear the contents of a cell or a selected range of cells, a selected row 

or column.  The Delete command does not affect the clipboard. 

To completely remove a row or column in the spreadsheet, and shift other rows and columns to fill the 

space, use the Remove command in the Edit menu (p. 31). 

Select all 

Shortcut: Ctrl+A 

This command is used to select the entire contents of the current window (does not affect the clipboard). 

Find 

Shortcut: Ctrl+F 

The Find command is used to search for a specific string or data entry, starting from the current cell pointer 

position. 

First the current column is searched through, starting at the current cell pointer position, from top to 

bottom.  If no match is found, you are offered the choice to continue the search in the next columns. 

The search specification can contain the ? and * wildcards.  The ? wildcard indicates that the character on 

this position can be ignored and, * indicates that the rest of the cell can be ignored.  For example: Jones 

matches Jon* and Jo?es. 

If the option Show formulas is selected and checked (see p. 36), then the search string is compared with 

the literal or raw contents of the cell, otherwise it is compared with the cells' calculated values.  E.g. if cell 

B10 contains SIN(90), resulting in 1.00, and the search string is `SIN*', then cell B10 will be ignored when 

Show formulas is OFF. 

FIND does not distinguish uppercase from lowercase characters. 

28