Default Row Height & column width Settings for new workbooks

[robbroy]

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]

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]

Dave - Thanks for the simple tip that will save me many keystrokes! robbroy