Formatting CellsOpenOffice Calc has two formatting options:
Styles allow you to make a formatting change to an entire spreadsheet easily. For instance, if you use a default cell style that specifies one font, you can change the font in the entire spreadsheet just by changing the font for the default style. Styles also can be shared with co-workers for company-wide standard spreadsheets.First, select the cells to be formatted. You can select a single cell by clicking it, a row or a column by clicking the letter or number, or any rectangular section of cells by dragging the mouse across the cells.To format from the Format menu, select Cells to see the window in Figure 12-2, which allows you to set many formatting optionsnumber format, alignment, borders, etc. Figure 12-2. Cell formatting window.Figure 12-1that provides the available styles, listed by type. The two icons above the list box switch the list between cell and page styles. To apply a style from the Stylist, double-click the desired cell style in the list.To create or modify a style, click Format on the menu bar and select Style Catalog. The Style Catalog window opens (shown in Figure 11-2), in which you can create or modify styles. When you press New or Modify, the window shown in Chapter 11.You can combine two or more cells into one cell. Select the cells you want to combine. Click Format. Select Merge Cells->Define. |