Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

It is pretty straightforward to create new cell styles in Excel 2010. My problem is that the new style I create is only available for that spreadsheet.

How can I create a global cell style that will be there with the Excel default styles each time I create a new spreadsheet? Is this possible?

share|improve this question

migrated from stackoverflow.com Nov 16 '10 at 14:44

This question came from our site for professional and enthusiast programmers.

2 Answers 2

The Styles object is a member of Workbook not Application. There is no way AFAIK to add a style to the built-in collection (the BuiltIn property is readonly).
But you could make a style you create available to new workbooks by including your new styles in a workbook template.
To modify the default template start with a blank workbook, create the styles you want, then save the workbook in your XLSTART directory as a template called Book.XLTX or Book.XLT

share|improve this answer

It is possible! See the website below.


share|improve this answer
Welcome to Super User! Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. –  nixda Feb 15 '13 at 14:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.