| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column width Q
Is there a way to change the column width measurement from the approx number of characters, to inches? -- earthshaker ------------------------------------------------------------------------ earthshaker's Profile: http://www.excelforum.com/member.php...o&userid=29947 View this thread: http://www.excelforum.com/showthread...hreadid=496439 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column width Q
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 Wed, 28 Dec 2005 11:00:30 -0600, earthshaker wrote: Is there a way to change the column width measurement from the approx number of characters, to inches? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| 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) | |||
Linear Mode
