Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
input of text longer than 5 rows
Hello!
I have two small problems. I have a cell, where line break is activated. When I input a text, which is longer than 5 rows, the cell gets the right value, but it displays only one row like this "##############". Is there a function to avoid this behaviour? Another problem is the following: I have three cells in one row, which are merged. The line break is activated. When I insert text, which is longer than one row, the line gets broken, but only one row is displayed, so the row height is not adjusted. Thanks for your answers. Regards Christian *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
input of text longer than 5 rows
Select the cell
Choose FormatCells On the Number tab, select the General category Click OK Christian Galbavy wrote: Hello! I have two small problems. I have a cell, where line break is activated. When I input a text, which is longer than 5 rows, the cell gets the right value, but it displays only one row like this "##############". Is there a function to avoid this behaviour? Another problem is the following: I have three cells in one row, which are merged. The line break is activated. When I insert text, which is longer than one row, the line gets broken, but only one row is displayed, so the row height is not adjusted. Thanks for your answers. Regards Christian *** Sent via Developersdex http://www.developersdex.com *** -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can no longer instert symbol in text box | Excel Discussion (Misc queries) | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
I can no longer Group rows | Excel Discussion (Misc queries) | |||
How to input additional text to multiple of existing cells that has text | Excel Worksheet Functions | |||
Tab between Text Boxes no longer working | Excel Programming |