::: Excel tips 6 :::

>> Copying styles between workbooks <<

Creating formatting styles is a real time saving 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:
. Open the source workbook and the destination workbook.
. Make sure that the destination workbook is active, go to the Format menu, and choose Style.
. Click the Merge button.
. Within the Merge Styles dialog box, select the source workbook from the Merge Styles From list box.
. Click OK.