Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing units
Hi, I need to change the size of a cell but they use pixels. can I change
that to inches? Mindy |
#2
|
|||
|
|||
Mindy
Assuming 96 pixels per inch you could approximate but at different resolutions your approximation can be off. If you want to use VBA to set height and width in mm which you then convert to inches at 25.4 mm per inch.......... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol Gord Dibben Excel MVP On Tue, 19 Apr 2005 21:10:03 -0700, "Mindy" wrote: Hi, I need to change the size of a cell but they use pixels. can I change that to inches? Mindy |
#3
|
|||
|
|||
One can set column widths and row heights in inches/cm/mm in Excel2004,
so perhaps that will be included in the next Windows version. In article , Gord Dibben <gorddibbATshawDOTca wrote: Assuming 96 pixels per inch you could approximate but at different resolutions your approximation can be off. If you want to use VBA to set height and width in mm which you then convert to inches at 25.4 mm per inch.......... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/...vbawssetrowcol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Secondary axis value units | Charts and Charting in Excel | |||
changing page break in an excel file | New Users to Excel | |||
Page margin units | Excel Worksheet Functions | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Problem with date base units for x axis | Charts and Charting in Excel |