OpenOffice.org OpenOffice - 3.0 User's Guide Page 160

  • Download
  • Add to my manuals
  • Print
  • Page
    / 275
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 159
Moving the cursor to a cell
To move around the spreadsheet and select the cell which has the
focus, 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 116 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 type in it.
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 accept the input made
in a cell or simply select a different cell. In case Impress wrongly
recognized the type of input, you can change it using the toolbar
shown in Figure 117, 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
Normally, for the purpose of a presentation, it may be necessary to
increase considerably the size of the font as well as matching it to the
style used in the presentation.
160 OpenOffice.org Impress Guide
Page view 159
1 2 ... 155 156 157 158 159 160 161 162 163 164 165 ... 274 275

Comments to this Manuals

No comments