Microsoft Office Tutorials and References
In Depth Information
Merging styles from other workbooks
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 turn on worksheet
protection, by choosing Review Changes Protect Sheet.
Note
Merging styles from other workbooks
It’s important to understand that custom styles are stored with the workbook in which they were
created. If you created some custom styles, you probably don’t want to go through all the work to
create copies of those styles in each new Excel workbook. A better approach is to merge the styles from
a workbook in which you previously created them.
To merge styles from another workbook, open both the workbook that contains the styles you want
to merge and the workbook into which you want to merge styles. From the workbook into which you
want to merge styles, activate the Style gallery and choose Merge Styles. The Merge Styles dialog box
opens with a list of all open workbooks. Select the workbook that contains the styles you want to
merge and click OK. Excel copies styles from the workbook you selected into the active workbook.
You may want to create a master workbook that contains all your custom styles so that you always
know from which workbook to merge styles.
Search JabSto ::




Custom Search