Default Row Height & column width Settings for new workbooks
Dave - Thanks for the simple tip that will save me many keystrokes! robbroy
"Dave Peterson" wrote:
Start a new workbook.
Set up everything you want--headers/footers/layout...
Save it as book.xlt in your XLStart folder.
Then excel will use that when you create a new workbook by clicking on the new
icon on the standard toolbar.
If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.
robbroy wrote:
Under the Tools\Options\General tab, I can set font type & size, # of
worksheets in each new workbook, etc. as the default for all new workbooks. I
would also like to set the default Row Height & Column width for all new
workbooks and worksheets, instead of having to manually reset these values
every time I start a new workbook. So far I haven't been able to figure out
how to do this on my own. Ideas anyone?
--
Dave Peterson
|