fix worksheet view for all new worksheets

W

whf

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

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
 
Top