Microsoft Office Tutorials and References
In Depth Information
Creating new styles
2. Right-click Normal in the Styles list and choose Modify.
Excel displays the Style dialog box, with the current settings for the Normal style.
3. Click the Format button.
Excel displays the Format Cells dialog box.
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, 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
Excel displays its Style dialog box, 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 display 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
checkmarks from the appropriate boxes.
5. Click OK to create the style and to close the dialog box.
After you perform these steps, the new custom style is available in the Style gallery. Custom
styles are available only in the workbook in which they were created. To copy your custom styles,
see the section that follows.
The Protection option in the Styles dialog box controls whether users can modify cells
for the selected style. This option is effective only if you also turned on worksheet
protection, by choosing Review