Set default column width for all new workbooks?

G

Guest

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?
 
B

Bob Phillips

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)
 
B

Bob I

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

Gord Dibben

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.

File>Save 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 File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...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 Insert>Sheet.

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


Gord Dibben Excel MVP
 
G

Guest

Perfect - thanks a lot, Bob
CW

Bob Phillips said:
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)
 
G

Guest

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
 

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

Top