Add a Dash of Style to Cell Data by Creating Custom Cell Styles

A cell style is a group of formatting elements such as fonts, font sizes, number formats, cell borders, and cell shading. Excel has pre-built cell styles that you can apply to your cells. If you are tired of using the existing cell styles in Excel 2010, or you need a style that needs to be made suitable for your data, you can try creating custom cell styles applying your own custom formats. This tutorial will show you how to create a custom cell style to help you highlight important cell data in the best manner.

 Steps to Creating Custom Cell Styles

1. On the Home tab, in the Styles group select Cell Styles.

2. In the gallery that is displayed, select New Cell Style.

3. The Style dialog box is displayed. If required, in the Style name text box, enter a style name.

4. Click the Format button to display the Format Cells dialog box is displayed.

5.In the Format Cells dialog box select a tab and apply the desired settings for the style and click OK.

6. In the Style dialog box check or uncheck the desired checkboxes to specify the
formatting attributes that are to be included in the style and click OK.

7. The new cell style is now displayed in the Cell Style gallery.

Now that you have used the steps detailed to create your own custom styles, use them to bring out the importance of your cell data.

RECOMMENDED BUY