
Moving the cursor to a cell
To move around the spreadsheet and select an active cell , you can:
• Use the arrow keys.
• Left-click with the mouse on the desired cell.
• Use the combinations Enter and Shift+Enter to move one cell
down or one cell up respectively; Tab key and Shift+Tab key to
move one cell to the right or to the left respectively.
Other keyboard shortcuts are available to move quickly to certain cells
of the spreadsheet. Refer to Chapter 5 (Getting Started with Calc) in
the Getting Started guide for further information.
Entering data
Keyboard input is received by the active cell, identified by a thick black
border (see Figure 128 where cell B3 is active). The cell reference (or
coordinates) is also shown on the left hand end of the formula bar.
To insert data, first select the cell to make it active, then start typing .
Note that the input is also added to the main part of the formula bar
where it may be easier to read.
Impress will try to automatically recognize the type of contents (text,
number, date, time, and so on) of a cell and apply default formatting to
it. Note how the formula bar icons change according to the type of
input, displaying Accept and Reject buttons ( ) whenever the input
is not a formula. Use the green Accept button to confirm the input
made in a cell or simply select a different cell. In case Impress wrongly
recognizes the type of input, you can change it using the toolbar shown
in Figure 129, or from Format > Cells in the main menu bar.
Tip
Sometimes it is useful to treat numbers as text (for example,
telephone numbers) and to prevent Impress from removing the
leading zeros or right align them in a cell. To force Impress to
treat the input as text, type a single apostrophe ' (U + 00B4)
before entering the number.
Formatting spreadsheet cells
Often, for the purposes of a presentation, it may be necessary to
increase the size of the font considerably or to match it to the style
used in the presentation.
The fastest and most flexible way to format the embedded spreadsheet
is to make use of styles. When working on an embedded spreadsheet,
Chapter 7 Including Spreadsheets, Charts, and Other Objects 169
Comentarios a estos manuales