G Guest Apr 6, 2007 #1 I wish to keep the view and scaling formats on all new worksheets I open in a workbook. How do I do this.
I wish to keep the view and scaling formats on all new worksheets I open in a workbook. How do I do this.
G Gord Dibben Apr 6, 2007 #2 You can open a new workbook and delete all but one sheet. Customize as you wish then File>Save As>File Type>MS Excel Template(*.xlt) Name it SHEET and store in your XLSTART folder. It now becomes the default Insert>Sheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP
You can open a new workbook and delete all but one sheet. Customize as you wish then File>Save As>File Type>MS Excel Template(*.xlt) Name it SHEET and store in your XLSTART folder. It now becomes the default Insert>Sheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP
