Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a variable row hieght in Excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a variable row hieght in Excel
You could use a macro:
Option Explicit Sub testme() Dim myAdjustment As Double Dim myRow As Range myAdjustment = 12 With Worksheets("Sheet1") With .UsedRange .Rows.AutoFit For Each myRow In .Rows myRow.RowHeight = myRow.RowHeight + myAdjustment Next myRow End With End With End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a variable row hieght in Excel
Absolutely perfect! Thank you very much!
"Dave Peterson" wrote: You could use a macro: Option Explicit Sub testme() Dim myAdjustment As Double Dim myRow As Range myAdjustment = 12 With Worksheets("Sheet1") With .UsedRange .Rows.AutoFit For Each myRow In .Rows myRow.RowHeight = myRow.RowHeight + myAdjustment Next myRow End With End With End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to graph x-variable versus y-variable in Excel ? | New Users to Excel | |||
Wrap around setting won't adjust row hieght | Excel Discussion (Misc queries) | |||
What is the difference between column width and row hieght? | Setting up and Configuration of Excel | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |