Home |
Search |
Today's Posts |
#1
|
|||
|
|||
WIDTH OF COLUMN
Is there any way to change the width of columns and row from pixels to
centimetres?????? REgards in advance |
#2
|
|||
|
|||
WIDTH OF COLUMN
No, but approximately 38 pixels or 28 points are 1 cm.
"qwerty" wrote in message ... Is there any way to change the width of columns and row from pixels to centimetres?????? REgards in advance |
#3
|
|||
|
|||
WIDTH OF COLUMN
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the 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. For an interesting and enlightening discussion on this subject see http://snipurl.com/dzz8 If you want to use VBA to set height and width in mm. Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Fri, 28 Oct 2005 14:31:02 -0700, qwerty wrote: Is there any way to change the width of columns and row from pixels to centimetres?????? REgards in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) |