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

100

101

Hiding and showing data

When elements are hidden, they are neither visible nor printed, but

can still be selected for copying if you select the elements around

them. For example, if column B is hidden, it is copied when you select

columns A and C. When you need a hidden element again, you can

reverse the process, and show the element.

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.

Figure 128: Hiding or showing cells

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 falls 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.

Chapter 5 Getting Started with Calc 169

Free eBook Edition

1 2 ... 164 165 166 167 168 169 170 171 172 173 174 ... 441 442

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

Comentarios a estos manuales

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

Comentarios a estos manuales

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