Microsoft Office Tutorials and References
In Depth Information
Merging styles from other workbooks
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. Excel
displays the Merge Styles dialog box, which shows 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 might want to create a master workbook that contains all your custom styles so that you
always know which workbook to merge styles from.
 
Search JabSto ::




Custom Search