Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows expand to fit text typed in?
Hi - I have my cells set up to wrap text. However, even with that, the row
height (which is not set to fixed height), does not expand to fit the text typed in. Is there a way in which I can get to "auto-expand" to fit whatever is typed into the row without just setting a really big fixed height? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows expand to fit text typed in?
You could use an event macro.
Rightclick on the worksheet tab that should have this behavior, select view code and paste this into the code window. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Target.EntireRow.AutoFit End Sub Amy wrote: Hi - I have my cells set up to wrap text. However, even with that, the row height (which is not set to fixed height), does not expand to fit the text typed in. Is there a way in which I can get to "auto-expand" to fit whatever is typed into the row without just setting a really big fixed height? Thank you! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows expand to fit text typed in?
If the cells are "merged" autofit won't happen.........even with Dave's
event code. If that is the case...................... See google search thread for code by Greg Wilson http://groups.google.com/group/micro...1c160cbeb27874 Gord Dibben MS Excel MVP On Mon, 28 Jul 2008 12:48:25 -0700, Amy wrote: Hi - I have my cells set up to wrap text. However, even with that, the row height (which is not set to fixed height), does not expand to fit the text typed in. Is there a way in which I can get to "auto-expand" to fit whatever is typed into the row without just setting a really big fixed height? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to minimize and expand the rows? | New Users to Excel | |||
how to minimize and expand the rows? | New Users to Excel | |||
How can I get the rows to expand before a total? | Excel Discussion (Misc queries) | |||
How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |