Operation Manual

Viewing Calc
Changing document view
Use the zoom function to show more or fewer cells in the window when you are working on a
spreadsheet. For more about zoom, see Chapter 1 Introducing LibreOffice in this guide.
Freezing rows and columns
Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of
a spreadsheet or both rows and columns. Then, when moving around within a sheet, the cells in
frozen rows and columns always remain in view.
Figure 104 shows some frozen rows and columns. The heavier horizontal line between rows 3 and
23 and the heavier vertical line between columns F and Q indicate that rows 1 to 3 and columns A
to F are frozen. The rows between 3 and 23 and the columns between F and Q have been scrolled
off the page.
Figure 104. Frozen rows and columns
Freezing rows or columns
1) Click on the row header below the rows you want the freeze or click on the column header
to the right of the columns where you want the freeze.
2) Go to Window on the main menu bar and select Freeze. A heavier line appears between
the rows or columns indicating where the freeze has been placed.
Freezing rows and columns
1) Click into the cell that is immediately below the rows you want frozen and immediately to
the right of the columns you want frozen.
2) Go to Window on the main menu bar and select Freeze. A heavier line appears between
the rows or columns indicating where the freeze has been placed.
Unfreezing
To unfreeze rows or columns, go to Window on the main menu bar and uncheck Freeze. The
heavier lines indicating freezing will disappear.
Splitting the screen
Another way to change the view is by splitting the screen your spreadsheet is displayed in (also
known as splitting the window). The screen can be split horizontally, vertically, or both, giving you
up to four portions of the spreadsheet in view at any one time. An example of splitting the screen is
shown in Figure 105 where a split is indicated by a black line.
Why would you want to do this? For example, a large spreadsheet in which one cell 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. This allows you to change the number in one cell and watch how it affects each of the
formulas.
Chapter 5 Getting Started with Calc | 129