Microsoft Office Tutorials and References
In Depth Information
Create your own
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
G ROUP F ORMATS AS A S TYLE
Click in a cell with formats you
want to use as the basis for a
Click the Home tab.
Click Cell Styles.
The Styles gallery appears.
Click New Cell Style.
l The Style dialog box appears.
l This area describes the formats of
the cell selected in Step 1.
Type a name for your style.
You can now apply the style
throughout the current