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 Show menu

Locking the cellpointer in a selected area of the spreadsheet

You can lock the cellpointer in a selected area, by first selecting the area of interest end next start entering data:

A. If the Enter key moves the cell pointer down (see Controlling the movement of the cellpointer in the spreadsheet), then when the cellpointer is at the bottom of the selected area, and you press the Enter key, then the cellpointer will move to the top cell in the next column of the selected area. E.g.

Locking the cellpointer in a selected area of the spreadsheet Locking the cellpointer in a selected area of the spreadsheet

B. If the Enter key moves the cell pointer right (see Controlling the movement of the cellpointer in the spreadsheet), then when the cellpointer is at the right side of the selected area, and you press the Enter key, then the cellpointer will move to the first cell in the next row of the selected area.

Note: for this to work you should only use the Enter key to move the cellpointer.