Copying styles between workbooks in Excel : A look
Creating formatting styles is a real timesaving trick for users. So why should they waste time re-creating these styles in multiple workbooks? If they have formatted a workbook in a particularly useful way and want to continue to use the format in other workbooks, teach them how to copy the style from one workbook to another:
1. Open the source workbook and the destination workbook.
2. Make sure that the destination workbook is active, go to the Format menu, and choose Style.
3. Click the Merge button.
4. Within the Merge Styles dialog box, select the source workbook from the Merge Styles From list box.
5. Click OK.