Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Row Sizing
Similar to property within a table in Word where you can specify the height
as "at least"... Within Excel is it possible to set a row(s) to begin as a set size (i.e.: 0.5") and auto fit if text requires a larger space? Perhaps a macro might be able to what I am asking, does anyone have a suggestion or code that works? Thanks in adavance for your assistance. Mike |
#2
|
|||
|
|||
highlight the entire sheet and double click on the line between 2 cells will resize all the column/row to fit the longer text string. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=387554 |
#3
|
|||
|
|||
I think you'll need a macro to assure the minimum height.
Option Explicit Sub testme() Dim myRowHeight As Double Dim myRow As Range Dim minHeight As Double minHeight = 16.5 For Each myRow In ActiveSheet.UsedRange.Rows myRow.AutoFit If myRow.RowHeight < minHeight Then myRow.RowHeight = minHeight End If Next myRow End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mike@ACM wrote: Similar to property within a table in Word where you can specify the height as "at least"... Within Excel is it possible to set a row(s) to begin as a set size (i.e.: 0.5") and auto fit if text requires a larger space? Perhaps a macro might be able to what I am asking, does anyone have a suggestion or code that works? Thanks in adavance for your assistance. Mike -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Auto Sizing | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Proportional sizing of scrollbox thumb | Excel Discussion (Misc queries) | |||
xl chart font sizing into PPT | Charts and Charting in Excel | |||
Sizing individual Cells | Excel Worksheet Functions |