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?

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?

Set the default column width on the sheets to 9.5 and then make it a
workbook template. (See Create template in help)

CW wrote:

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?

First off...........the 8.43 is not cm

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

If you want all new workbooks to be 9.5 width............

Open a new workbook. Customize as you wish.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Tue, 7 Aug 2007 09:32:04 -0700, CW wrote:

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?

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?

Thanks Bob
CW

"Bob I" wrote:

Set the default column width on the sheets to 9.5 and then make it a
workbook template. (See Create template in help)

CW wrote:

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?

Hi,

Procedure for changing the width from 8.43 to 9.5.

1. Open a New Workbook.
2. Do one of the following:
Press Ctrl+A to select the active worksheet
-or-
Press the Ctrl key and click on each worksheet tab to group
3. Click on the separator between A and B header. You will notice that the
current Width is 8.43(64 pixels).
4. Press the right mouse button on Column separator and move the right to
increase the width to 9.5.
5. On the File menu, click Save As
The Save As dialog box is displayed.
6. In Save As type list, select Template (*.xlt) .
7. In the Save in list, select the folder XLSTART under the Excel folder in
your local machine.
8. Click Save to store this file as a template file.

Deselecting Worksheet tab
To deselect the sheet tab, do one of the following:
A. Press the Ctrl key and click on each sheet.
-or-
Right-click on the sheet tab and select Ugroup Sheet.

__________________________________________________ _______________

For more information please refer to section "Measurement units and rulers
in Excel" below:

Measurement units and rulers in Excel

Unlike Microsoft Word, Excel does not provide a horizontal or vertical
ruler, and there is no quick way to measure the width or height of a
worksheet in inches. Excel uses characters, points, and pixels as units of
measurement.

The width of cells is displayed in characters and pixels rather than in
inches. When you drag the boundary of a column heading to adjust the width of
a column on the worksheet, a ScreenTip displays the width in characters and
shows pixels in parentheses.

The height of cells is displayed in points and pixels rather than in inches.
When you drag the boundary of a row heading to adjust the height of a row on
the worksheet, a ScreenTip displays the height in points and shows pixels in
parentheses.

An approximate conversion of points and pixels to inches is shown in the
following table.

Points Pixels Inches
18 24 .25
36 48 .5
72 96 1
108 144 1.5
144 192 2

Challa Prabhu


"CW" wrote:

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?