OpenOffice.org OpenOffice - 3.3 Guía de usuario descargar pdf (Pagina 145)

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, you can access the cell styles

created in Calc and use them. However, a better approach is to create specific cell

styles for presentation spreadsheets, as the Calc cell styles are likely to be unsuitable

when working within Impress.

To apply a style to a cell or group of cells simultaneously (or manually format their

cell attributes), first select the range to which the changes will apply. A range

consists of one or more cells, normally forming a rectangular area. A selected range

consisting of more than one cell can be recognized easily because all its cells are

shaded. To select a multiple-cell range:

1) Click on the first cell belonging to the range (either the left top cell or the right

bottom cell of the rectangular area).

2) Keep the left mouse button pressed and move the mouse to the opposite corner

of the rectangular area which will form the selected range.

3) Release the mouse button.

To add further cells to the selection, hold down the Control key and repeat the steps

1 to 3 above.

Tip

You can also click on the first cell in the range, hold down the Shift key,

and click in the cell in the opposite corner. Refer to Chapter 5 (Getting

Started with Calc) in the Getting Started book for further information on

selecting ranges of cells.

Some shortcuts are very useful to speed up selection and are listed below:

• To select the whole visible sheet, click on the blank cell between the row and

column indexes, or press Control+A.

• To select a column, click on the column index at the top of the spreadsheet.

• To select a row, click on the row index on the left hand side of the spreadsheet.

Once the range is selected, you can modify the formatting, such as font size,

alignment (including vertical alignment), font color, number formats, borders,

background and so on. To access these settings, choose Format > Cells from the

main menu bar (or right-click and choose Format Cells from the pop-up menu). This

command opens the dialog box shown in Figure 132.

If the text does not fit the width of the cell, you can increase the width by hovering

the mouse over the line separating two columns until the mouse cursor changes to a

double-headed arrow; then click the left button and drag the separating line to the

new position. A similar procedure can be used to modify the height of a cell (or group

of cells).

150 OpenOffice.org 3.3 Impress Guide

1 2 ... 140 141 142 143 144 145 146 147 148 149 150 ... 247 248

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía de usuario Pagina 145

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3