set default row height and col width settings?

  • Thread starter Thread starter gls858
  • Start date Start date
Hi Gls858,
Can you set the default row height and column width for
new worksheets?
Click to expand...

Format a workbook the way you want it and save it as Book.XLT, file
type Template, in your XLSTART directory (below the directory from
which Excel is loaded).

Any new workbook created, will be based on this workbook

Copy a worksheet from this workbook and save it as Sheet.XLT ,as above.

Any new sheet you insert will be based on that sheet.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Jan said:
Hi Gls858,




Format a workbook the way you want it and save it as Book.XLT, file
type Template, in your XLSTART directory (below the directory from
which Excel is loaded).

Any new workbook created, will be based on this workbook

Copy a worksheet from this workbook and save it as Sheet.XLT ,as above.

Any new sheet you insert will be based on that sheet.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
Click to expand...
Thanks for the help.

gls858
 
Back
Top