To hide or show sheets, rows, and columns, use the options on the Format menu or
the right-click (context) menu. For example, to hide a row, first select the row, and
then choose Format > Row > Hide (or right-click and choose Hide).
To hide or show selected cells, choose Format > Cells from the menu bar (or right-
click and choose Format Cells). On the Format Cells dialog, go to the Cell Protection
tab.
Outline group controls
If you are continually hiding and showing the same cells, you can simplify the process
by creating outline groups, which add a set of controls for hiding and showing the
cells in the group that are quick to use and always available.
If the contents of cells fall into a regular pattern, such as four cells followed by a
total, then you can use Data > Group and Outline > AutoOutline to have Calc add
outline controls based on the pattern. Otherwise, you can set outline groups manually
by selecting the cells for grouping, then choosing Data > Group and Outline >
Group. On the Group dialog, you can choose whether to group the selected cells by
rows or columns.
When you close the dialog, the outline group controls are visible between either the
row or column headers and the edges of the editing window. The controls resemble
the tree-structure of a file-manager in appearance, and can be hidden by selecting
Data > Group and Outline > Hide Details. They are strictly for online use, and do
not print.
The basic outline controls have plus or minus signs at the start of the group to show
or hide hidden cells. However, if outline groups are nested, the controls have
numbered buttons for hiding the different levels.
If you no longer need a group, place the mouse cursor in any cell in it and select
Data > Group and Outline > Ungroup. To remove all groups on a sheet, select
Data > Group and Outline > Remove.
62 OpenOffice.org 3.3 Calc Guide
Comentarios a estos manuales