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. TIP | The Stylelist provides existing styles, and you can define your own from text you select before displaying the Stylelist. | -
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 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. -
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. -
Close the Stylelist Once you've applied the styles, close the Stylelist dialog box to return to your formatted spreadsheet. -
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. -
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. |