change column width

  • Thread starter change standard column width
  • Start date
C

change standard column width

i want to change the standard column witdh from 8.43 to other value
i want this setting to be saved in the excel program not in the xls file
all supported files to be opend with the new column width
 
G

Gord Dibben

Cannot be done unless you create a Template with the settings you wish.

Only newly-created files will have the settings.

Existing files will have to be altered one by one as you open them.

Save the workbook/template as Book.XLT and place it in your Office\XLSTART
folder. You can also make a Sheet.XLT and this will be your Insert>Worksheet
default. Place it also in XLSTART folder.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Excel Column Width in XLSX 0
change standard column width 1
Table Preferred width is changed when pasting 1
Excel 2007 default column width different to 2003 1
VBA - (re-) Set a Table Style 2
Autonumber field in Excel that behaves the same as Access 0
Column widths in Excel 2013 16

Top