Microsoft Office Tutorials and References
In Depth Information
to another workbook
A style is a collection of formats you use within a
workbook. With styles, you maintain consistency in
the way numbers, dates, times, borders, and text
appear in cells. You can create a style based on any
combination of formats available in the Format Cells
dialog box, which you access by clicking the Format
button in the Styles dialog box. One workbook can
contain many styles.
Styles simplify your work and reduce the time
required to format worksheets. With styles, you can
change many cells at once by creating a style and
applying the style to other cells. To use a style in
another workbook, copy the style from one workbook
to the other. When you copy a style into another
workbook, Excel calls that merging.
To copy styles, you need to open both the workbook
from which you want to copy the style and the
workbook to which you want to apply it.
Open the file with your custom
Open the workbook into which
you want to merge styles.
Click the Home tab.
Click Cell Styles.
The Styles gallery appears.
Click Merge Styles.