setting inches in MS Excel

  • Thread starter Thread starter Sanra Holroyd
  • Start date Start date
S

Sanra Holroyd

Can someone tell me how to adjust the measurement setting
in Excel to inches?

Thanks.

Sandra Holroyd
 
Sandra:

Never given it a thought before, since everything in Excel is
scaleable, unlike Word.

I don't think it has a meaning in respect of Excel other than in the
size of paper you choose to print on.

Obviously the calculations (apart from a few conversion functions) are
units-independent. Charts are scaleable. Print setup is very
scaleable.

Sooooo...AFAIK, you don't need (or get) a measurement setting.

Alf
 
Sandra

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
 
Back
Top