OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 143)

100

101

Unfreezing

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

mark by Freeze will vanish.

Splitting the window

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.

Figure 106. Split screen example

Splitting the screen horizontally

To split the screen horizontally:

1) Move the mouse pointer into the vertical scroll bar, on the right-

hand side of the screen, and place it over the small button at the

top with the black triangle.

Figure 107. Split screen bar on vertical scroll bar

Chapter 5 Getting Started with Calc 143

Split screen bar

1 2 ... 138 139 140 141 142 143 144 145 146 147 148 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 143

Comments to this Manuals

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