Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto height rows
I have created a form which has a section for rogue items on a protected
sheet. These rogue items can extend to a number of lines and by means of a button the rows will auto adjust. However, my standard row height is 17.25 whereas the default is 12.75 and in adjusting the rows automatically, any rows with single line of text revert to the default height. Is there any way of overiding the default to keep my standard height and also of adding the additional 4.5 to any rows with two or more lines of text. Many thanks in anticipation. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto height rows
the trick I use is to include some (empty) cells in those rows at a larger font size. (arial 14 will give you 20pixels row height.) then autosizing will always work. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Quindos wrote : I have created a form which has a section for rogue items on a protected sheet. These rogue items can extend to a number of lines and by means of a button the rows will auto adjust. However, my standard row height is 17.25 whereas the default is 12.75 and in adjusting the rows automatically, any rows with single line of text revert to the default height. Is there any way of overiding the default to keep my standard height and also of adding the additional 4.5 to any rows with two or more lines of text. Many thanks in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto height | Excel Worksheet Functions | |||
Auto fit row height | Excel Worksheet Functions | |||
Auto Fit on Row Height | Excel Discussion (Misc queries) | |||
Row Height - Auto-Fit | Excel Discussion (Misc queries) | |||
Non printing rows and auto height rows. | Excel Programming |