How to Create your own Style in Excel 2007
By using Excel’s many format options, you can easily format numbers, text, and cells. A style is a named
collection of formats you can share among users and apply across workbooks. Styles streamline the work of
formatting so you and others can apply a consistent set of formats to worksheet elements such as row
heads, column heads, and data values. Excel comes with many styles, which you can view in the Style
gallery. To apply one of Excel’s styles, select the cells you want to apply it to and then click the style. You can create your own styles. To create a new style based on the current one, right-click the style in the
Cell Styles gallery and then click Modify. The Style dialog box appears. Click Format. The Cells dialog
box appears. Use the dialog box to select one or more formats. Click OK when you finish. Back in the
Style box, give your new style a name, and then click OK. Here is how to achieve this:
1. Click in a cell with formats you want to use as the basis for a style.
2. Click the Home tab.
3. Click Cell Styles. The Styles gallery appears.
4. Click New Cell Style. The Style dialog box appears. This area describes the formats of the cell selected in Step 1.
5. Type a name for your style.
6. Click OK.
You can now apply the style throughout the current workbook.
How to Apply a format style
1. Click and drag to select the cells to which you want to apply the style.
2. Click the Home tab.
3. Click Cell Styles. The Style gallery appears.
4. Click the style you created.
You can use the Format Painter to apply styles, and you can copy, and paste formats from one cell to another. However, if you use a format often, consider creating a style.
You can aslo build a style from the ground up rather than basing it on a formatted cell. Click the Home
tab and then click Cell Styles. The Style gallery appears. Click New Cell Style and then in the Style
dialog box click Format. The Format cells dialog box appears. You can then use it to design your style.
