Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto adjust row height on merged columns w/wrapped text?
I am developing a form for capital requisitions that requires detail to be
entered regarding the project. To make it simple for the user, I would like the rows to auto adjust their height as the person types their text. This row of data is merged across several columns. Text box is out of the question as is asking them to watch their margins if they just type across a row that isn't wrapped. This is a KISS (keep it simple, stupid) project. I appreciate anyone's help!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto adjust row height on merged columns w/wrapped text?
Why are you using Excel? Use Word, and then click insert field--Fillin.
(note you will need to scrowl down to use this feature. The outcome is you will get a text box that allows any text entry to be added to the document, Use it as may times in a document as necessary to give the flexability of fill in information, yet maintain structure of the document. Hope this is helpful Bill "ExcelBee" wrote: I am developing a form for capital requisitions that requires detail to be entered regarding the project. To make it simple for the user, I would like the rows to auto adjust their height as the person types their text. This row of data is merged across several columns. Text box is out of the question as is asking them to watch their margins if they just type across a row that isn't wrapped. This is a KISS (keep it simple, stupid) project. I appreciate anyone's help!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto adjust row height on merged columns w/wrapped te
There are many drop down boxes and formulas in the rest of the form. It
would be difficult to incorporate all of them into Word. I found the answer to the problem; it is VB code that is applied to the worksheet. Now the text wraps and expands as one types. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto adjusting merged cells with wrap text on | Excel Discussion (Misc queries) | |||
Can a Text Box be Formatted in Columns? | Excel Discussion (Misc queries) | |||
how to see the whole text in merged cells? | New Users to Excel | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Auto fit merged cells | Excel Discussion (Misc queries) |