Excel-colume with size

[Mango]

hi all..i'm a new user off Microsoft Excel,i have a
question abt Excel here.what format did Microsofe Excel
using for the colum measurement?"cm"?"mm"?"point"?or else?
can the format be change? if can,how to change it?

 

[JE McGimpsey]

In all WinXL and most MacXL versions, the units are the number of
numeric characters of the standard font that will fit in the cell. The
standard font is set in Tools/Options/Preferences.

With MacXL 2004, by default you set the width directly in inches or
centimeters. You can also set the width as the number of numeric
characters.

 

[mango]

oh...thats mean i have no other way to set the colum size
in "cm" or other format?then how i need to adjust those
cell colum to print on the specific form?

 

[CLR]

Column width can be adjusted by clicking on the dividing line between the
column of interest and the next one to the right and just dragging the
dividing line to whatever width you want. It can also be auto-adjusted by
just double-clicking on that dividing line.......or highlight the column,
then Format > Column > Autofit selection..............then, the overall
Printing can be sized in the Print setup utility.............

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Mango

Any object that is measured in inches or centimeters.....Text Box, Drawing
Object, List Box from the Forms Toolbar for instance or Comment Box size,
would be determined by the measurment system set in your Windows Regional
Settings.

Row heights are measured in points. There are 72 points to an inch.

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.

No relationship between the two.

If you want to use VBA to set height and width in mm....which you could
convert to inches.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

Gord Dibben Excel MVP