141 Sheet
• On the Edit menu, use Find 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.
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 Desktop 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 Desktop screen).
You can also change the width of columns and the height of rows, to suit the
information contained in them.
ENTERING INFORMATION
To Next Page
Loading...