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.

This site uses cookies to store information on your computer. More info...