Ms.Excel Tips Customize the Templates Dialog and Default Workbook:
6 views
Skip to first unread message
Tiger
Oct 29, 2011, 2:00:28 AM10/29/11
to MS Excel Macro Vba
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:
https://sites.google.com/site/excelknowitall/home/chapter-6
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:
https://sites.google.com/site/excelknowitall/home/chapter-6
Reply all
Reply to author
Forward
0 new messages