Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Height/Width measurements
I want to make custom templates in excel for, e.g., file folder labels.
How can I ( or CAN I?) change the units-of-measurement for row height and column width to inches as opposed to whatever the default is? Thanks! MrBill |
#2
|
|||
|
|||
You can (in fact MacXL04 allows you to set height and width in
inches/cm), but you'd probably be better off using Word's Tools/Label Wizard, drawing from your XL file as the data source. One of the label options is for file folder labels. See Word's Help for more on Labels, or see http://www.mvps.org/dmcritchie/excel/mailmerg.htm In article , MrBill wrote: I want to make custom templates in excel for, e.g., file folder labels. How can I ( or CAN I?) change the units-of-measurement for row height and column width to inches as opposed to whatever the default is? Thanks! MrBill |
#3
|
|||
|
|||
Yeah ... but I like to do things the hard way. :O)
Seriosuly, though, I'll give your reply careful attention and see if I can make it work. But - to beg the original question - you said you can use in/cm in MacXL04 ... but can you do it in WinXL2000? "JE McGimpsey" wrote: You can (in fact MacXL04 allows you to set height and width in inches/cm), but you'd probably be better off using Word's Tools/Label Wizard, drawing from your XL file as the data source. One of the label options is for file folder labels. See Word's Help for more on Labels, or see http://www.mvps.org/dmcritchie/excel/mailmerg.htm In article , MrBill wrote: I want to make custom templates in excel for, e.g., file folder labels. How can I ( or CAN I?) change the units-of-measurement for row height and column width to inches as opposed to whatever the default is? Thanks! MrBill |
#4
|
|||
|
|||
MrBill
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, 18 May 2005 10:41:03 -0700, MrBill wrote: Yeah ... but I like to do things the hard way. :O) Seriosuly, though, I'll give your reply careful attention and see if I can make it work. But - to beg the original question - you said you can use in/cm in MacXL04 ... but can you do it in WinXL2000? "JE McGimpsey" wrote: You can (in fact MacXL04 allows you to set height and width in inches/cm), but you'd probably be better off using Word's Tools/Label Wizard, drawing from your XL file as the data source. One of the label options is for file folder labels. See Word's Help for more on Labels, or see http://www.mvps.org/dmcritchie/excel/mailmerg.htm In article , MrBill wrote: I want to make custom templates in excel for, e.g., file folder labels. How can I ( or CAN I?) change the units-of-measurement for row height and column width to inches as opposed to whatever the default is? Thanks! MrBill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fitting individual measurements into a specific length | Excel Worksheet Functions | |||
Change default measurements from cm to inches | Setting up and Configuration of Excel | |||
Metric to imperial measurements | Excel Discussion (Misc queries) | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
Default page margin measurements in Excel 2000 | Excel Discussion (Misc queries) |