Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default Row Height & column width Settings for new workbooks
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default Row Height & column width Settings for new workbooks
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
height and width settings locked? | Excel Discussion (Misc queries) | |||
Row height/column width | Excel Discussion (Misc queries) | |||
Row height and Column Width to cms. or inches | Excel Discussion (Misc queries) | |||
Column Width and Row Height | Excel Worksheet Functions | |||
Change default height/width of up/down arrow, heading, bottom bar | Excel Discussion (Misc queries) |