Psion Teklogix 32M/64M Manual Do Utilizador

Sheet

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.

PPPPPerforming calculations

erforming 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.