OpenOffice.org OpenOffice - 3.0 User's Guide download pdf (Page 161)

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,

the best 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 (or indeed manual formatting of the cell attributes) to

a cell or group of cells simultaneously, first select the

range

to which

the changes will apply. A range consists of one or more cells, normally

forming a rectagular area. A selected range consisting of more than

one cell can be recognized easily because all its cells except the active

one have a black background. 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 the selection:

• To select the whole visible sheet, click at the intersection between

the rows indexes and the 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 118.

Chapter 7 Inserting Spreadsheets, Charts, and Other Objects 161

1 2 ... 156 157 158 159 160 161 162 163 164 165 166 ... 274 275

Comments to this Manuals

No comments

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

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0