Microsoft Office Tutorials and References
In Depth Information
Doing It in Styles
replace the generic style name (Style 1, Style 2, and so on) with your own
descriptive name before you click OK.
Excel then adds a sample of your new style — the style name formatted, with
the new style’s attributes — to a Custom section at the top of the Cell Styles
gallery. To apply this custom style to a cell selection, you then only have to
click its sample in the Custom section of the Cell Styles gallery.
The custom cell styles you create don’t become part of the current workbook
until the next time you save the workbook. Therefore, you need to remember
to click the Save button on the Quick Access toolbar or press Ctrl+S to save
your changes after creating a new cell style if you want that style to remain
part of the workbook’s Cell Styles gallery the next time you open the
workbook in Excel.
Copying custom styles from
one workbook into another
Excel makes it easy to copy custom cell styles that you’ve saved as part
of one workbook into the workbook you’re currently working on. To copy
custom styles from one workbook to another, follow these steps:
1. Open the workbook that needs the custom styles added to it from
another existing workbook.
This can be a brand new workbook or one that you’ve opened for editing
(see Chapter 4).
2. Open the workbook that has the custom styles you want to copy saved
as part of it.
See the previous section, “Creating a new style for the gallery” for tips
on how to create and save cell styles.
3. Switch back to the workbook into which you want to copy the saved
You can do this by clicking the workbook’s button on the Windows
taskbar or using the Flip feature by pressing Alt+Tab until you select the
workbook’s thumbnail in the center of the display.
4. Click the Cell Styles button on the Home tab followed by Merge Styles
in the Cell Styles gallery or press Alt+HJM.
Excel opens the Merge Styles dialog box.
5. Click the name of the open workbook file that contains the custom
styles to copy in the Merge Styles From list box and then click OK.