How do I set default workSHEETs?

[CanvasShoes]

I would like to make the excel book.xltx template so that not only does the main workBOOK open with my desired formatting, but any time I open a new sheet it opens with my desired formatting.



I've googled high and low and can't find where there are any instructions for this.

Thanks in advance...

[thetraininglady]

If you just want to set the Default Font then you can do that through Excel Options. Go into the File tab and select Options. On the General tab you will see an area for When creating new workbooks and you can select a Default Font and Font Size plus the default view for new worksheets and number of sheets included in new workbooks.