Microsoft Office Tutorials and References
In Depth Information
Creating new styles
Cells, by default, use the Normal style. Here’s a quick example of how you can use styles to change
the default font used throughout your workbook:
1. Choose Home Styles Cell Styles.
Excel displays the list of styles for the active workbook.
2. Right-click Normal in the Styles list and choose Modify.
The Style dialog box opens with the current settings for the Normal style.
3. Click the Format button.
The Format Cells dialog box opens.
4. Click the Font tab and choose the font and size that you want as the default.
5. Click OK to return to the Style dialog box.
6. Click OK again to close the Style dialog box.
The font for all cells that use the Normal style changes to the font that you specified. You can change
any formatting attributes for any style.
Creating new styles
In addition to using the built-in Excel styles, you can create your own styles. This flexibility can be
quite handy because it enables you to apply your favorite formatting options very quickly and
To create a new style from an existing formatted cell, follow these steps:
1. Select a cell and apply all the formatting that you want to include in the new style.
You can use any of the formatting that’s available in the Format Cells dialog box.
2. After you format the cell to your liking, activate the Style gallery and choose New Cell Style.
The Style dialog box opens, along with a proposed generic name for the style. Note that
Excel displays the words “By Example” to indicate that it’s basing the style on the current cell.
3. Enter a new style name in the Style Name box.
The check boxes show the current formats for the cell. By default, all check boxes are
4. If you don’t want the style to include one or more format categories, remove the check
marks from the appropriate boxes.
5. Click OK to create the style and close the dialog box.
Search JabSto ::

Custom Search