Change format of default new worksheet

[Jim Gordon]

I know how to make a template that has a custom default worksheet very nicely formatted. But when I click the + sign to add a new worksheet, it is formatted with the regular Excel defaults. I'd like to customize what I assume is a hidden worksheet so that when I click the + sign to add a worksheet my customized version is used.

If m assumption is correct that there is a hidden worksheet that's used as a template, how do I customize that worksheet?

 

[Micron]

does this paragraph help?
Automatically open a workbook template or worksheet template when you create a new workbook or worksheet

 

[Jim Gordon]

I already know how to do that. If I customize the workbook and make it the default, when I add a new worksheet the new worksheet does not inherit the customizations. Instead it seems that some hidden worksheet is used to generate additional worksheets.

 

[Micron]

Sorry; when it said

when you create a new workbook or worksheet

I guess I misunderstood that you could create a sheet template and use it for new sheets.

 

[Jim Gordon]

Sorry; when it said

I guess I misunderstood that you could create a sheet template and use it for new sheets.

My Bad! It didn't register in my brain that I needed to save a second workbook called Sheet.xltx as well as the Book.xltx. Excel opens both of those files when it opens.

Thanks for sticking with me. It worked!

 

[Micron]

Great! Not that I will ever likely need it, but nice to know it works. If you have a solution, it's nice to mark the thread as solved for the sake of others looking for unsolved problems.

 

[Alex Blakenburg]

And just to round out the discussion, if you have created a custom "table" style you like and want to reuse.
• Paste a table that has your custom style applied into your template
• You can delete the Table and the custom Table style or even the sheet you copied it on to and it will stick when you resave your template file, so that it available the next time you call up you Book.xltx or Sheet.xltx