Ms.Excel Tips Customize the Templates Dialog and Default Workbook:
If you tend to perform the same tasks or use the same spreadsheet layouts again and again, you can build your own Template tab into Excel's standard Insert Template dialog to provide a quick starting point. Imagine you have a spreadsheet containing days of the year and formulas summarizing various data for the days.
You have formatted this spreadsheet beautifully with your company colors, logo, and required formulas, and you need to use it on a daily basis. Instead of reinventing the wheel (or copying and deleting what you don't need) each day, you can save yourself a lot of time and trouble by creating a template.
Read More: