>Dear Sir/Madam
>
>In Excel for Column width when we enter 8 or 9 what does 8 stand for in Inches or cm . And if i want a printout of 1 Inch Cloumn width what is it measuring unit no matter what ever font i use.
It seems to be a residue from the days of DOS, with fixed-width characters. One unit is approximately one character. This is no longer exact, since in most fonts, characters have a variable width. Also, you can choose larger or smaller fonts.
The formula for the column width seems to be: width of columns in pixels = (arbitrary units * 7) + 5. Or simply multiply by 7 for an approximation - perhaps the +5 is for the borders, but I am not sure.
I think you can substitute pixel for "point" (1/72 inch), but you will have to do some experimenting to confirm this.
>
>And if possible or available addon for Excel ruler.
You can do some things in preview. Mainly, if you drag the margins, you will see numbers representing the width of the margin.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)