Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Modify width
Start a new workbook. Do all the stuff you like for each worksheet in that
workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Peter Kwong wrote: I want to see if I can modify the default width when I open all excel documents. Instead of say 8.43 in the first column width have it be like 9.5 And that setting on all files that I open. Is that possible? Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Modify width
What if I want existing excel files that I open to have a modified width in
the first column how do i do that? The problem is that some .csv files that I open have ##### in the first column. Trying to find a way to save a step. "Dave Peterson" wrote: Start a new workbook. Do all the stuff you like for each worksheet in that workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Peter Kwong wrote: I want to see if I can modify the default width when I open all excel documents. Instead of say 8.43 in the first column width have it be like 9.5 And that setting on all files that I open. Is that possible? Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Modify width
You would need an application event that would lurk in the background waiting
for you to open a workbook. Then it would go through each worksheet and adjust the columnwidth of column A. But this sounds very dangerous to me. If you open a workbook that is nicely formatted and shouldn't change, you might have trouble stopping that application event from firing. Aother option would be to record a macro while you adjust the columnwidth the way you want. Then just run that macro whenever you felt like it. Lots of people create a workbook named personal.xls where they keep these kinds of utilities. They store this personal.xls in their XLStart folder so that each time excel opens, so does their utility workbook. Peter Kwong wrote: What if I want existing excel files that I open to have a modified width in the first column how do i do that? The problem is that some .csv files that I open have ##### in the first column. Trying to find a way to save a step. "Dave Peterson" wrote: Start a new workbook. Do all the stuff you like for each worksheet in that workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Peter Kwong wrote: I want to see if I can modify the default width when I open all excel documents. Instead of say 8.43 in the first column width have it be like 9.5 And that setting on all files that I open. Is that possible? Thanks -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Modify width
Thanks for the info.
"Dave Peterson" wrote: You would need an application event that would lurk in the background waiting for you to open a workbook. Then it would go through each worksheet and adjust the columnwidth of column A. But this sounds very dangerous to me. If you open a workbook that is nicely formatted and shouldn't change, you might have trouble stopping that application event from firing. Aother option would be to record a macro while you adjust the columnwidth the way you want. Then just run that macro whenever you felt like it. Lots of people create a workbook named personal.xls where they keep these kinds of utilities. They store this personal.xls in their XLStart folder so that each time excel opens, so does their utility workbook. Peter Kwong wrote: What if I want existing excel files that I open to have a modified width in the first column how do i do that? The problem is that some .csv files that I open have ##### in the first column. Trying to find a way to save a step. "Dave Peterson" wrote: Start a new workbook. Do all the stuff you like for each worksheet in that workbook. Save it as a template file named book.xlt in your XLStart folder. Each time you click on the new icon, that new workbook will inherit all the settings from that template file. If you want new worksheets added to existing workbooks to have these same settings, set up another workbook template file (one sheet only???) and name it sheet.xlt. Save it in the same XLStart folder. Peter Kwong wrote: I want to see if I can modify the default width when I open all excel documents. Instead of say 8.43 in the first column width have it be like 9.5 And that setting on all files that I open. Is that possible? Thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine a cell's width and enter it in the cell | Excel Discussion (Misc queries) | |||
Adjust an Excel table with the width of a Word page | Excel Discussion (Misc queries) | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) | |||
Column Width Behavior | Excel Discussion (Misc queries) |