Show All

Hide All

If you want to make the styles (style: A combination of formatting characteristics, such as font, font size, and indentation, that you name and store as a set. When you apply a style, all of the formatting instructions in that style are applied at one time.) that you create in or copy into a workbook available in all future workbooks, you can save them in a template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.) that is used for all new workbooks.

1. Open the workbook that contains the styles that you want to make available.
2. Click New to open a new, blank workbook.
3. In the blank workbook, click Style on the Format menu.
4. Click Merge.
5. In the Merge styles box, double-click the workbook that contains the styles that you want to make available, and then click OK.

   Note  If the two workbooks contain styles with the same names, you receive a message asking whether you want to merge these styles. To replace the styles in the active workbook with the copied styles, click Yes. To keep the styles in the active workbook, click No. You receive this message only once, regardless of the number of conflicting style names.

6. On the File menu, click Save As.
7. In the File name box, type book.
8. In the Save as type list, click Template.
9. In the Save in list, click the XLStart folder.

   Note  The XLStart folder is usually located in C:\Program Files\Microsoft Office\Office11\XLStart.

10. Click Save.

Note  After you exit and restart Excel, the styles that you saved in book.xlt will be available in all new workbooks that you create by clicking New .