View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CW CW is offline
external usenet poster
 
Posts: 54
Default Set default column width for all new workbooks?

Perfect - thanks a lot, Bob
CW

"Bob Phillips" wrote:

Open a new blank workbook.

Change all the columns to width 9.5

Save the workbook as a template file (type xlt) and store as Book.xlt in the
XLSTART directory.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"CW" wrote in message
...
Using Excel 2003, the col width is set to 8.43 cm by default.
I want to make this 9.5cm for every new workbook that I create, by
default.
How do I set this?