set default row height and col width settings?

[gls858]

Can you set the default row height and column width for
new worksheets?

gls858

 

[Jan Karel Pieterse]

Hi Gls858,

Can you set the default row height and column width for
new worksheets?

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

 

[gls858]

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

Thanks for the help.

gls858