user manual

46Sheet
Moving aroundMoving around
Moving aroundMoving around
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 informationEntering information
Entering informationEntering information
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 containa’atthebeginning, 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).