Copy styles from another workbook
- Open the workbook that contains the styles you want to copy.
- Open the workbook you want to copy the styles to, and then click Style on the Format menu.
- Click Merge.
- In the Merge styles box, double-click the workbook that contains the styles you want to copy.
Note If the two workbooks contain styles with the same names, you must confirm that you want to merge these styles. To replace the styles in the active workbook with the copied styles, click Yes. To keep the styles in the active workbook, click No. This warning occurs only once, regardless of the number of conflicting style names.