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.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: