Creating and Applying Styles

graphics/microsoft26.gif

A style is a defined collection of formats ”font, font size, attributes, numeric formats, and so on ”that you can store as a set and later apply to other cells . For example if you always want subtotals to display in blue 14-point Times New Roman, bold, italic, with two decimal places and commas, you can create a style that includes all these formats. If you plan to enter repetitive information, such as a list of dollar amounts in a row or column, it's often easier to apply the desired style to the range before you enter the data. That way you can simple enter each number, and Excel formats it as soon as you press Enter. You can also copy styles from one workbook to another. Once you create a style, it is available to you in every workbook.

Create a New Style

graphics/one_icon.jpg

Select a cell or range that you want to create a style.

graphics/tow_icon.jpg

Click the Format menu, and then click Style.

graphics/three_icon.jpg

Type the name of the new style.

graphics/foure_icon.jpg

Clear the check boxes with the options you do not want.

graphics/five_icon.jpg

Click Modify.

graphics/six_icon.jpg

Click any of the formatting tabs, and then make additional formatting changes to the style.

graphics/seven_icon.jpg

Click OK.

graphics/eight_icon.jpg

Click OK.

graphics/05inf24.jpg

graphics/05inf25.jpg

Did You Know?

You can merge a style from another workbook . Click the Format menu, click Style, click Merge, click the workbook that contains the style you want, click OK, and then click OK again.

Apply a Style

graphics/one_icon.jpg

Select a cell or range to which you want to apply a style.

graphics/tow_icon.jpg

Click the Format menu, and then click Style.

graphics/three_icon.jpg

Click the Style Name list arrow, and then select the style you want to apply.

graphics/foure_icon.jpg

Click OK.

graphics/05inf26.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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