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

100

101

Autoformatting cells and sheets

You can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or

a selected cell range.

1) Select the cells that you want to format, including the column and row

headers.

2) Choose Format > AutoFormat.

3) To select which properties (number format, font, alignment, borders, pattern,

autofit width and height) to include in an AutoFormat, click More. Select or

deselect the required options. Click OK.

Figure 56: Choosing an AutoFormat

If you do not see any change in color of the cell contents, choose View > Value

Highlighting from the menu bar. This function only affects cells with numerical

data.

Note

If the selected cell range does not have column and row headers,

AutoFormat is not available.

Defining a new AutoFormat

You can define a new AutoFormat that is available to all spreadsheets.

1) Format a sheet.

2) Choose Edit > Select All.

3) Choose Format > AutoFormat. The Add button is now active.

4) Click Add.

5) In the Name box of the Add AutoFormat dialog, type a meaningful name for the

new format.

6) Click OK to save. The new format is now available in the Format list in the

AutoFormat dialog.

Chapter 2 Entering, Editing, and Formatting Data 59

1 2 ... 54 55 56 57 58 59 60 61 62 63 64 ... 433 434

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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