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

100

101

Fill tool, selection lists, and the ability to input information into

multiple sheets of the same document.

Using the Fill tool on cells

At its simplest, the Fill tool is a way to duplicate existing content. Start

by selecting the cell to copy, then drag the mouse in any direction (or

hold down the Shift key and click in the last cell you want to fill), and

then choose Edit > Fill and the direction in which you want to copy:

Up, Down, Left or Right.

Caution

Choices that are not available are grayed out, but you can still

choose the opposite direction from what you intend, which

could cause you to overwrite cells accidentally unless you are

careful.

Tip

A shortcut way to fill cells is to grab the “handle” in the lower

right-hand corner of the cell and drag it in the direction you

want to fill.

Figure 110: Using the Fill tool

You can also use the fill tool selecting some existing series of data that

you want to extend. If the interval between the values in the selected

cells is constant, Calc will try to guess and fill the selection with values

that continue the sequence. For example, if you select three cells

containing the values 1, 2 and 3 and fill the subsequent cell Calc will

insert the value 4.

Using a fill series

A more complex use of the Fill tool is to use a fill series. The default

lists are for the full and abbreviated days of the week and the months

of the year, but you can create your own lists as well.

Chapter 5 Getting Started with Calc 147

1 2 ... 142 143 144 145 146 147 148 149 150 151 152 ... 432 433

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.0 Guía de inicio rápido Pagina 147

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.0