Psion Teklogix 32M/64M, netBook manual Moving around, Entering information

Moving around

The current cell is indicated by a dark border around a cell. The information you enter in the input line applies to this cell.

∙Tap any cell to select it, or use the arrow keys to move around. You can use the scrollbars or the arrow keys to move to other areas of the worksheet. Hold down the Ctrl key and use the arrow keys to move by a whole screen at a time.

∙Use the Find commands on the Edit menu to move to other cells. Use Find and Find next to move to cells if you know their content, or Go to to jump to a specific cell.

Note: You can alter the number of cells displayed by using the zoom commands, or by setting the zoom level using the command on the View menu.

Highlight more than one cell to perform actions which apply to an area:

∙To highlight more than one cell: drag the pen from the first cell in the block to cover the desired cells, or hold down Shift and use the arrow keys.

∙To highlight a whole column or a whole row: tap the shaded column or row heading, e.g. “C” or “2”.

∙To highlight the entire worksheet: tap the square in the top left corner of the worksheet headings.

Entering information

To enter information in a cell, select it and start typing. You will see the information you are entering on the input line. The first character you type tells Sheet what kind of information the cell will contain:

∙To enter numbers: begin with a number or with one of

these characters: . - + and (.

∙To enter text: simply type it in. If your text starts with a number, type a ’ first, e.g. ’24 Longton Road. If you want the text itself to contain a ’ at the beginning, type two of them, e.g. ’’97 sales figures.

∙To enter a formula for a calculation: begin with a =. For example, to make a given cell display the sum of the contents of cells B1 and B2, type in =B1+B2.

∙To edit the information in a cell: simply highlight the cell and press Enter. You can then edit the contents on the input line.

∙To enter a date: type the day, month and year on the input line, separating them with a space or the date separator character as set in the System screen, e.g. 1 Oct 69 or 1 10 69, or 10 1 69 if you use this date format.

∙To enter a time: type the hour, minutes and seconds, separating them with a colon (or the time separator character as set in the System screen).

Sheet 46