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.

cellstyle1.jpg

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.

cellstyle2.jpg

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.

cellstyle3.jpg

To access our new cell style - or any of the built-in styles - select
Format - Style Catalog

cellstyle4.jpg

As you can see, a custom TurquoiseBGround style is now available for
selection and can be applied to any selected range of cells.

cellstyle5.jpg

Leave a Reply