Psion Teklogix netBook, 32M/64M manual Performing calculations, Or column and tap

You can also change the width of columns and the height of rows, to suit the information contained in them. To do this:

∙Drag the right-hand edge of the column heading to adjust its width, and the lower edge of the row heading to adjust its height.

∙Use the commands on the Format menu to set the height of a row in points and the width of a column in characters.

Note: If you enter more text than can be displayed in the current cell, the information will run over into the next column if that column is empty, so you may want to adjust the column width. If you enter a number that’s too long for the cell, you will see a series of # signs in the cell, though the actual number will still be stored.

∙To freeze panes on the worksheet: type the information you wish to “freeze” in the rows and columns, position the pointer in the cell below the row to freeze, and to the right of the column to freeze (this will often be B2). Tap the button, or select the command from the View menu. The “frozen” panes will stay on screen when scrolling through the rest of the worksheet.

∙To protect the worksheet from changes: select the Protection command from the Tools menu.

∙To allow changes to some cells only: highlight the area for which you wish to allow changes, select the Protection command on the Tools menu and remove the tick to “unlock” the highlighted cells. If you then protect the worksheet, changes are only allowed to the cells that are not locked.

Sheet 47

Performing calculations

There are two ways to perform calculations:

∙Type the calculation into a single cell. When you press Enter or move to another cell, the result will be displayed on the worksheet.

∙Use a formula for a calculation; just type the different parts of your calculation in separate cells and note their references, e.g. income in B2 and tax in C2. In a new cell, enter the formula, beginning with a =. Use the cell references for the components of the calculation rather than the numbers themselves. For example, =C2-(B2*C2). The value displayed in this cell is calculated for whatever values you use in the component cells.

Note: If you have a row or column of cells and want to know their sum, position the pointer in the cell at the end of the row

or column and tap the button. Sheet will insert the formula

for the sum of the preceding group of cells and calculate the result.