Save cell styles to use in all new workbooks

If you want to make the cell styles that you create in or copy into a workbook available in all future workbooks, you can save them in a template that is used for all new workbooks.

1. Open the workbook that contains the styles that you want to make available.

2. Click the Microsoft Office Button , click New and then, under Blank and recent, double-click Blank Workbook.

3. On the Home tab, in the Styles group, click Cell Styles.

   

   Tip: If you do not see the Cell Styles button, click Styles, and then click the More button next to the cell styles box.

4. Click Merge Styles.

5. In the Merge Styles dialog box, in the Merge styles from box, click the workbook that contains the styles that you want to copy, and then click OK.

6. If both workbooks contain styles that have identical names, you must indicate whether you want to merge these styles by doing the following:

   • To replace the styles in the active workbook with the copied styles, click Yes.

   • To keep the styles in the active workbook as they are, click No.

     Note: Excel displays this message only once, regardless of the number of pairs of identical style names.

7. Click the Microsoft Office Button , and then click Save As.

8. In the File name box, type Book.

9. In the Save as type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you want to make available in the template.

10. In the box where you specify the location in which to save a file, locate and select the XLSTART folder.

    Note: In Windows Vista, the XLSTART folder is typically located in C:\Users\<user name>\AppData\Local\Microsoft\Excel\XLSTART folder. In Microsoft Windows XP, the XLSTART folder is typically located in C:\Documents and Settings\<user name>\Application Data\Microsoft\Excel\XLSTART folder.

11. Click Save.

Note: After you exit and restart Excel, the cell styles that you saved in Book.xltx (or Book.xltm) will be available in all new workbooks that you create.