65 Create a Calc Style

 <  Day Day Up  >  

Using a style is simple. You can apply a style to selected cells to format those cells with the style's formatting. Calc comes with several styles, and you can add your own.

Before You Begin

64 About Calc Styles and Templates

Suppose you routinely create income statements for various departments. You might develop three separate sets of character formats that work well, respectively, for the title of the income statements, the data that comprises the body of the income statements, and the profit or loss line at the bottom of the income statement.

See Also

66 Create a Calc Template

Instead of defining each of these cell formats every time you create the income statement, you can create three styles and store the styles under their own names (such as IS Heading, IS Data , and IS ProfitLoss ). The next time you create the income statement, you need only to select a style such as IS Title before typing the title. When you then type the title, the title looks the way you want it to look without your having to take the time to designate any format.

One of the easiest ways to apply a style is to keep the Stylelist dialog box showing at all times by pressing F11 (or by selecting Stylelist from the Format menu). If you don't have the screen room to keep the Stylelist showing, you can display it when you want to apply a style and then click its Close button to hide the Stylelist once again.



The Stylelist provides existing styles, and you can define your own from text you select before displaying the Stylelist.

  1. Select the Cell Text for the Style

    When you want to apply a predefined style to text, first select the cell or range. The format of the cell will completely change depending on which style you apply, but the data inside the cell will not change.

  2. Display the Stylelist

    Press F11 to display the Stylelist dialog box. If you see the page styles and not the cell styles, click the Cell Styles button. The style names will then appear that you can apply to your selected cells.

  3. Select the Style

    Double-click the style in the Stylelist that you want to apply to the selected range. Depending on the arrangement of your screen and windows , you can usually see the style immediately applied to your selected text. If you want to try a different style, double-click another in the list. Feel free to keep the Stylelist dialog box showing or click Close to hide it, depending on how much you plan to use the Stylelist during the rest of your editing session.

  4. Close the Stylelist

    Once you've applied the styles, close the Stylelist dialog box to return to your formatted spreadsheet.

  5. Select a Formatted Range

    You can easily add your own styles. You add styles to Calc's Stylelist by example. In other words, format a cell or range to match a style you want to create and then tell Calc to create a new style based on that format.

    To add the new style to the Stylelist dialog box, press F11 to display the Stylelist dialog box after selecting the formatted range in the sheet.

  6. Type a New Style Name

    Click the New Style from Selection button, the second button from the right atop the Stylelist dialog box. Calc displays the Create Style dialog box.

    Type a name for your style (one that does not already exist in the Stylelist, unless you want to replace one). When you click OK , Calc creates the new style based on your selected text. The next time you select that kind of cell and select the new style, Calc applies the new style's formatting to the cell without you having to worry about the formatting details for that cell ever again.

 <  Day Day Up  >  

Sams Teach Yourself OpenOffice.org All In One
Sams Teach Yourself OpenOffice.org All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net