« Basic functions : SUMIF | Main | Adding a background graphic »
December 13, 2004
Creating Custom Cell Styles
If you find yourself making the same style adjustments to the default cell style repeatedly, you may want to consider setting your own customized cell style that can be readily applied to a selected range of cells.Select any cell and apply the style attributes you want. Close the Cell Format dialog window after making your changes. Now select Format - Stylist as shown below to open the Cell Styles dialog.
The Cell Styles dialog has a number of icons along the top. Click on the second icon from the right which will create a new style based on the selected cell in the Cell Style dialog as shown below.
In the example, we set the background colour to turquoise - so will will call our new style "TurquoiseBGround". Click OK and then close the dialog.
To access our new cell style - or any of the built-in styles - select Format - Style Catalog
As you can see, a custom TurquoiseBGround style is now available for selection and can be applied to any selected range of cells.
Posted by Dave at December 13, 2004 03:47 AM