If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
set default row height and col width settings?
Can you set the default row height and column width for
new worksheets? gls858 |
#2
|
|||
|
|||
set default row height and col width settings?
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 |
#3
|
|||
|
|||
set default row height and col width settings?
Jan Karel Pieterse wrote:
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 Thanks for the help. gls858 |
Thread Tools | |
Display Modes | |
|
|