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

100

101

You can set the freeze point at one row, one column, or both a row and

a column as in Figure 110.

Freezing single rows or columns

1) Click on the header for the row below where you want the freeze

or for the column to the right of where you want the freeze.

2) Choose Window > Freeze.

A dark line appears, indicating where the freeze is put.

Freezing a row and a column

1) Click into the cell that is immediately below the row you want

frozen and immediately to the right of the column you want

frozen.

2) Choose Window > Freeze.

Two lines appear on the screen, a horizontal line above this cell

and a vertical line to the left of this cell. Now as you scroll around

the screen, everything above and to the left of these lines will

remain in view.

Unfreezing

To unfreeze rows or columns, choose Window > Freeze. The check

mark by Freeze will vanish.

Splitting the screen

Another way to change the view is by splitting the window, also known

as splitting the screen. The screen can be split either horizontally or

vertically or both. This allows you to have up to four portions of the

spreadsheet in view at any one time.

Why would you want to do this? Imagine you have a large spreadsheet

and one of the cells has a number in it which is used by three formulas

in other cells. Using the split screen technique, you can position the

cell containing the number in one section and each of the cells with

formulas in the other sections. Then you can change the number in the

cell and watch how it affects each of the formulas.

152 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 147 148 149 150 151 152 153 154 155 156 157 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 152

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 152

Comentarios a estos manuales

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