OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 36)

100

101

Figure 27. Frozen rows and columns

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 horizontally, vertically, or both.

You can therefore have up to four portions of the

spreadsheet in view at any one time.

Why would you want to do this? An example would

be a large spreadsheet in which one of the cells

has a number in it that 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.

36 OpenOffice.org 3.3 Calc Guide

Figure 28. Split screen example

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 36

Comentarios a estos manuales

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