Section 66. Create a Calc Style

66. Create a Calc Style


65 About Calc Styles and Templates


67 Create a Calc Template

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.

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.

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.

One of the easiest ways to apply a style is to keep the Styles and Formatting window visible at all times by pressing F11 (or by choosing Format, Styles and Formatting ). If you don't have enough room on your screen to keep the Styles and Formatting window displayed, you can choose to show it only when you need it.


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

66. Create a Calc Style.

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.

Display the Styles and Formatting Window

Press F11 to display the Styles and Formatting window. 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.

Select the Style

Double-click the style in the list 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 Styles and Formatting window dialog box showing or click Close to hide it, depending on how much you plan to use the Style list during the rest of your editing session.

Close the Styles and Formatting window

Once you've applied the styles, close the Styles and Formatting window to return to your formatted spreadsheet.

Select a Formatted Range

You can easily add your own styles. You add styles to Calc's list 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, press F11 to display the Styles and Formatting window after selecting the formatted range in the sheet.

Type a New Style Name

Click the New Style from Selection button, the second button from the right atop the Styles and Formatting window. Calc displays the Create Style dialog box.

Type a name for your style (one that does not already exist in the list, 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. 2, Firefox, and Thunderbird for Windows All in One
Sams Teach Yourself 2, Firefox and Thunderbird for Windows All in One
ISBN: 0672328089
EAN: 2147483647
Year: 2005
Pages: 232
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: