Modifying a Style

graphics/microsoft26.gif

Any style ”whether it was supplied by Excel or created by you or someone else ”can be modified. Suppose you created a style containing fonts and colors your company uses. If those specifications changed, you could modify the style to include the new attributes. If you want to use styles created or modified in another workbook, you can merge the styles into the open workbook. If you no longer use a style, you can delete it from the workbook.

Modify a Style

graphics/one_icon.jpg

Click the Format menu, and then click Style.

graphics/tow_icon.jpg

Click the Style Name list arrow.

graphics/three_icon.jpg

Click the style you want to modify.

graphics/foure_icon.jpg

Click Modify.

graphics/five_icon.jpg

Make any changes you want in the Format Cells dialog box.

graphics/six_icon.jpg

Click OK.

graphics/seven_icon.jpg

Click OK.

graphics/05inf27.jpg

graphics/05inf28.jpg

graphics/05inf29.jpg

Merge Styles

graphics/one_icon.jpg

Open the worksheet that contains the styles you want to merge.

graphics/tow_icon.jpg

Click the Format menu, and then click Style.

graphics/three_icon.jpg

Click Merge.

graphics/foure_icon.jpg

Click the workbook that contains the styles you want to merge with the current workbook.

graphics/five_icon.jpg

Click OK.

graphics/six_icon.jpg

Click OK.

graphics/05inf30.jpg

graphics/05inf31.jpg

Delete a Style

graphics/one_icon.jpg

Click the Format menu, and then click Style.

graphics/tow_icon.jpg

Click the Style Name list arrow, and then click the style you want to delete.

graphics/three_icon.jpg

Click Delete.

graphics/foure_icon.jpg

Click OK.

graphics/05inf32.jpg

Did You Know?

You can use the Add button to create a new style based on a current style . You never know when you might want to use an original style supplied by Excel. To keep the original style intact, modify the formatting in the Style dialog box as desired, click Add, and then give the modified style a new name.



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