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.

http://office.microsoft.com/en-us/excel-help/save-cell-styles-to-use-in-all-new-workbooks-HP001216733.aspx

share|improve this answer
1  
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

 
discard

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