OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

66. Create a Calc Style

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.

TIP

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.

[View full size image]

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.

OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

فارسی

کردی

العربیه

اردو

Türkçe

Русский

English

Français

کانال فیلم من

تبیان من

فایلهای من

کتابخانه من

پنل پیامکی

وبلاگ من

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] - نسخه متنی

Greg Perry, M. T. Cozzola, Jennifer Fulton

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

فونت

اندازه قلم

حالت نمایش

66. Create a Calc Style