OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido descargar pdf (Pagina 129)

Changing part of the data in a cell

Sometimes it is necessary to change the contents of cell without removing all of the

contents, for example if the phrase “See Dick run” is in a cell and it needs to be

changed to “See Dick run fast.” It is often useful to do this without deleting the old

cell contents first.

The process is the similar to the one described above, but you need to place the

cursor inside the cell. You can do this in two ways.

Using the keyboard

After selecting the appropriate cell, press the F2 key and the cursor is placed at

the end of the cell. Then use the keyboard arrow keys to move the cursor through

the text in the cell.

Using the mouse

Using the mouse, either double-click on the appropriate cell (to select it and place

the cursor in it for editing), or single-click to select the cell and then move the

mouse pointer up to the input line and click into it to place the cursor for editing.

Formatting data

The data in Calc can be formatted in several ways. It can either be edited as part of a

cell style so that it is automatically applied, or it can be applied manually to the cell.

Some manual formatting can be applied using toolbar icons. For more control and

extra options, select the appropriate cell or cells, right-click on it, and select Format

Cells. All of the format options are discussed below.

Note

All the settings discussed in this section can also be set as a part of the

cell style. See Chapter 4 (Using Styles and Templates in Calc) in the

Calc Guide for more information.

Formatting multiple lines of text

Multiple lines of text can be entered into a single cell using automatic wrapping or

manual line breaks. Each method is useful for different situations.

Using automatic wrapping

To set text to wrap at the end of the cell, right-click on the cell and select Format

Cells (or choose Format > Cells from the menu bar, or press Ctrl+1). On the

Alignment tab (Figure 114), under Properties, select Wrap text automatically and

click OK. The results are shown in Figure 115.

Chapter 5 Getting Started with Calc 129

1 2 ... 124 125 126 127 128 129 130 131 132 133 134 ... 378 379

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido Pagina 129