Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Row Height = ??

Hey folks! I want to print out tabs for Case Logic CD storage sleeves.
I use these sleeves to store my collection of live shows. I plan to
use Excel, since my list is in this format and I can C&P the info I
want on the tabs. My question is about adjusting the height of the
rows (and column width) to fit the slot they go in. Are the
height/width numbers in inches, milimeters, or something different? If
so, is there a way to convert this number to inches or milimeters? I
couldn't find anything regarding this. Thanks for your help! Rich
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Row Height = ??

You might have better luck using mail merge in Word with Excel as the
source. You will have better control there.

Width is in the width of the default font for the character zero.
Height is in points I believe. Check Excel VBA help for rowheight and
columnwidth

Returns the height of all the rows in the range specified, measured in

points. <<
One unit of column width is equal to the width of one character in the

Normal style. For proportional fonts, the width of the character 0 (zero) is
used. <<


Settings can not be continuously set - there are only discrete increment
limitations in my experience.

Excel is not a good platform for page layout type operations.

--
Regards,
Tom Ogilvy


Rich G wrote in message
m...
Hey folks! I want to print out tabs for Case Logic CD storage sleeves.
I use these sleeves to store my collection of live shows. I plan to
use Excel, since my list is in this format and I can C&P the info I
want on the tabs. My question is about adjusting the height of the
rows (and column width) to fit the slot they go in. Are the
height/width numbers in inches, milimeters, or something different? If
so, is there a way to convert this number to inches or milimeters? I
couldn't find anything regarding this. Thanks for your help! Rich



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
Set a minimum row height a the same time with autofit row height Julie B New Users to Excel 2 May 5th 23 07:44 PM
Row Height stopped growing and Auot-Fit Row Height does not work PSULionRP Excel Discussion (Misc queries) 0 May 19th 09 07:59 PM
the row height should be excatly the height of the data jaggu Excel Discussion (Misc queries) 2 November 6th 08 10:30 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
resize row height and column height Tom Setting up and Configuration of Excel 3 April 3rd 05 02:03 PM


All times are GMT +1. The time now is 02:59 AM.

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

About Us

"It's about Microsoft Excel"