Sheet 142
To change the width of columns and the height of rows:
• 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.
• On the Format menu, use the commands 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 , or select the
command on the View menu. The frozen panes will stay on screen
when scrolling through the rest of the worksheet.
To protect the worksheet from changes:
• On the Tools menu, select Protection.
To allow changes to some cells only:
• Highlight the area you for which you wish to allow changes. On the
Tools menu, select Protection 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.
You can perform 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 .
Sheet will insert the formula for the sum of the preceding group of cells and
calculate the result.
There are two types of cell reference you can use in a formula:
• Relative references, such as A2. These get updated when copied and
moved elsewhere. For example, a reference to cell A2 in a formula in
cell B3 will change to B2 if the formula is copied to cell C3.
PERFORMING CALCULATIONS
To Next Page
Loading...