Row Height and Column Width in millimeters

[Guest]

How can I set column width and row height in millimeters ? Or as an alternative - how can I convert the numbers given (i.e. 12.75 and 17 pixels) to millimeters

Thank yo

Skipstjorinn

 

[Gord Dibben]

Skip

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

 

[Guest]

Thanks for your repl

I have tried to use the VBA code made by Ole. In his example he sets the row and column height and width to 35 millimeters. However when I print out the results I get 37 in width and 34 millimeters in height

The tip about objects measured in millimeters. That I could use - but I only get height and width in percentage. How could I change that to show millimeters? That would definitely do the trick since I could then set row height and column width in accordance to the object size

Many thanks

Skipper

 

[Gord Dibben]

Skipper

The 37 and 34 could be your particular printer.

The percentages you see for object height and width are for scaling only. You
should also have an actual size measurement on the same dialog screen.

Excel takes its settings for inches vs metric from Windows Settings.

Start>Settings>Control Panel>Regional and Language Options>Regional
Options>Customize>Number.

Change to Metric. Close3 and re-start Excel.

Gord Dibben Excel MVP