Excel: Share Styles Between Workbooks

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I created the CommaGood style as discussed in the last topic. But, it is only in the workbook that I used. Do I really have to do this for every single workbook?

Strategy: Styles that you create are available only in the current workbook. It would be better if you could globally make the style available to all workbooks.

There are two approaches that you can use.

In the first approach, you create a sample workbook that contains all your favorite custom styles. You can copy those styles to any workbook by following these steps:

  1. Open the new workbook and the sample styles workbook.
  2. Make the new workbook the active workbook.
  3. Open the Cell Styles menu and choose Merge.
  4. In the Merge Styles dialog, choose to merge from the sample styles workbook. Excel will copy the styles to the new workbook.

This approach is admittedly a hassle because you would have to apply the styles to every workbook you ever create.

An easier approach is to save your styles in Book.xltx. See "œControl Settings for Every New Workbook and Worksheet" on page 40.


For more resources for Microsoft Excel