Thread: Modify width
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
Peter Kwong
 
Posts: n/a
Default 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