Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 02:28 PM
MrBill
 
Posts: n/a
Default 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   Report Post  
Old May 18th 05, 03:50 PM
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 06:41 PM
MrBill
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 11:23 PM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fitting individual measurements into a specific length Eric Excel Worksheet Functions 0 April 21st 05 11:49 PM
Change default measurements from cm to inches EMRhelp.org Setting up and Configuration of Excel 1 April 9th 05 12:17 AM
Metric to imperial measurements Gill.star Excel Discussion (Misc queries) 7 March 7th 05 01:57 AM
Can I use xy scatter charts to plot absolute measurements? Wattie Charts and Charting in Excel 0 February 6th 05 03:29 PM
Default page margin measurements in Excel 2000 J. L. Engel Excel Discussion (Misc queries) 1 December 8th 04 07:41 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017