Creating and Using Styles (MS EXCEL)

Creating and Using Styles

A combination of formats for a cell is called a style. You can use styles to simplify the formatting of your documents. You’ll find that by using styles, you can provide a consistent look to all your documents.

Displaying the formatting attributes that you can specify in a cell style. Notice that cell A1 is selected. Procedure: choose Format, Style. The Style dialog box will display and it will show the six formatting attributes. These attributes are the settings of Normal style. By default, all cells in all worksheets use the Normal style. The settings of the Normal style do not precisely match the formatting of the current cell, A1. That’s because a cell can contain additional formatting on top of the style that is applied to it. If you assign a new style name to the combination of formats in cell A1, you’ll create a style. Procedure: in the Style Name box, type My Title, click on Ok.

when you create a style by assigning a name to a cell that has already been formatted, you are creating a style “by example.” Using the new style. Procedure: 1. select cell A3, choose Format, Style. From the Style Name drop-down list, select My Title. Click on Ok. another method you can use to create styles is called “by definition”. With this method, you assign the attributes you want from the Style dialog box. Procedure: select cell A5. As you press the Shift key, select cell D5. Display the style dialog box. Using the “by definition” method to create a style. In the Style Name box, type My Heading click on Modify. The Format cells dialog box will display. Select the Font tab. In the Font box, type Times New Roman select the Patterns tab. In the Cell Shadding, color area, select the light shade of gray. Click on Ok. click OK again. Click outside to deselect the cell.

You can apply cell formatting to any cell without affecting the style formatting, because any cell can contain additional formatting on top of the style that is applied to it. To redefine a style, you must change the style’s attributes by using the Style dialog box.

Regards,

BEM T. CELESTINE