View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Aussie Bob C Aussie Bob C is offline
external usenet poster
 
Posts: 24
Default Using a variable row hieght in Excel

Change row one to 12pt Arial font.
Check & note the row height.
Move down the row numbers until the curser changes to a cross hair, right
click & select Row Height from menu & note the row height.
Change row one back to 10pt Arial font.
Select all rows by clicking on the square to the left of the column letter A.
Move down the row numbers until the curser changes to a cross hair, right
click & select Row Height from menu, enter the row height for 12 pt.
While all rows are selected go to format cells and change vertical alignment
to center.

This can be done with a VBA macro.


--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.


"jerrybdot" wrote:

Auto Row Height puts the row lines too close to the text. I would like to
have "Auto Height + 12pts" or something like that, so the text and the lines
are not so cluttered together. Something like we can already do in paragraph
settings in Word.

Details: Each row has a different number of lines of text.

I don't want to manually adjust each row (which is what I am doing now),
since there will be more text added to the document as time goes on.

I am using Ariel 10pt and it must stay Ariel 10pt.

Thank you for any suggestions! Jerrybdot