Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I wanted to use a customized Excel template for all new files. Sure, I can create a new template in the templates folder and in Excel use New and select my template or double-click on the template file.

But I wanted to use that template also when I'm creating a new file from the Explorer context menu with mouse right click -> Create New. It takes always the built-in(?) template.

How can I get Excel and Windows Explorer to behave this way?

share|improve this question

Save your template in the XLStart folder with the name book.xltx (as a template, extension depending on your version of excel).

XLStart folder can be found here:

Excel 2000 - C:\Program Files\Microsoft Office\Office\XLStart\

Excel XP - C:\Program Files\Microsoft Office\Office 10\XLStart\

Excel 2003 - C:\Program Files\Microsoft Office\Office 11\XLStart\

*Excel 2007 - C:\Program Files\Microsoft Office\Office 12\XLStart*

Next time you open a new excel document, it will use this template.

share|improve this answer
I know this, but it does not work as expected. No clue. – PeterMmm Feb 15 '11 at 14:48
Ok, for the right click menu, it might be linked to a different template in the registry. Try to follow the answer in this link . I assume for you, under the .xlsx filetype, there is already a filename. Change that to your template name and try again. – Yoh Feb 15 '11 at 15:08
@PeterMmm can you inform us if this worked this way? – Yoh Feb 22 '11 at 0:07

I finally solved this. Open the C:\Windows\ShellNew folder. There will be a Microsoft Excel file in there. It was called EXCEL12.XLSX on my machine with Office 2010, though I'll guess the number might change depending on the version of Office. Replace this file with whatever you want. You can even edit it in place.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.