WRAP TEXT IN EXCEL
Claude021
Posted messages
71
Registration date
Status
Membre
Last intervention
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello, I have a small problem. I have an Excel file that contains two sheets. In each sheet, I have a column from L6 to L40 that is a comments column. On one of the sheets, when I write comments in the comments column, I was able to enable Wrap Text by checking the Wrap Text box, and everything is fine as the row expands by itself when I reach the end of the comments column. However, on the second sheet, it doesn't work at all. Did I forget something?
Can someone help me please?
Thanks
Claude
Configuration: Windows XP / Internet Explorer 7.0
Can someone help me please?
Thanks
Claude
Configuration: Windows XP / Internet Explorer 7.0
6 réponses
Hello Raymond
I believe I miscommunicated; what I want is quite simple. When we write something in a cell and set it to (cell format-Alignment-Wrap text), I apologize, but in Excel in English, we indicate that it should not exceed the cell format. Normally, once the text is written and is too large for the cell, we should enlarge the row of the cell to see all the text clearly. I would like to know why this happens automatically in one sheet and not in the other, where I have to resize the cell myself.
Thank you
Claude
I believe I miscommunicated; what I want is quite simple. When we write something in a cell and set it to (cell format-Alignment-Wrap text), I apologize, but in Excel in English, we indicate that it should not exceed the cell format. Normally, once the text is written and is too large for the cell, we should enlarge the row of the cell to see all the text clearly. I would like to know why this happens automatically in one sheet and not in the other, where I have to resize the cell myself.
Thank you
Claude
Hello
Normally, once the text is written and is too large for the cell, the row of the cell should be enlarged
It also depends on how you document your cell:
- if you type in Excel, it follows the previously defined format.
- if you paste text, your line break mode may not be taken into account in some cases.
- and there are probably other similar cases when pasting.
Since you want this option for the entire column, the easiest way is to select the column and check the option in the cell format to resize the rows of the column once you are done with your modifications.
It is worth noting that row resizing works for enlarging but not for decreasing if you enlarge the column.
This option seems to react to many parameters, and even when managed by a macro, the result is quite difficult to adjust precisely: many topics on the forum can testify to this.
--
Stay calm
Normally, once the text is written and is too large for the cell, the row of the cell should be enlarged
It also depends on how you document your cell:
- if you type in Excel, it follows the previously defined format.
- if you paste text, your line break mode may not be taken into account in some cases.
- and there are probably other similar cases when pasting.
Since you want this option for the entire column, the easiest way is to select the column and check the option in the cell format to resize the rows of the column once you are done with your modifications.
It is worth noting that row resizing works for enlarging but not for decreasing if you enlarge the column.
This option seems to react to many parameters, and even when managed by a macro, the result is quite difficult to adjust precisely: many topics on the forum can testify to this.
--
Stay calm
Hello,
Raymond, "Wrap Text" is the English equivalent of "Renvoyer à la ligne automatiquement" (in cell format), I'm not great at English either, but VBA requires it!
Claude, with Excel 2003, when the "Renvoyer à la ligne automatiquement" format is checked, the automatic row height adjustment works both for increasing and decreasing the height during input (even during copy/paste or special value paste).
For the automatic row height adjustment to work, it is imperative that the row height is set to Automatic and therefore it should not have been defined with a fixed value.
With the French version, the command is: Format, Row, Automatic Adjustment, I think you won't have any difficulty finding the equivalent in English.
However, the automatic adjustment does not occur with the result of a formula; it has to be requested after each change in the result.
Best regards
Patrice
--
Nicolas always says: "It's easy when you know the answer!"
Raymond, "Wrap Text" is the English equivalent of "Renvoyer à la ligne automatiquement" (in cell format), I'm not great at English either, but VBA requires it!
Claude, with Excel 2003, when the "Renvoyer à la ligne automatiquement" format is checked, the automatic row height adjustment works both for increasing and decreasing the height during input (even during copy/paste or special value paste).
For the automatic row height adjustment to work, it is imperative that the row height is set to Automatic and therefore it should not have been defined with a fixed value.
With the French version, the command is: Format, Row, Automatic Adjustment, I think you won't have any difficulty finding the equivalent in English.
However, the automatic adjustment does not occur with the result of a formula; it has to be requested after each change in the result.
Best regards
Patrice
--
Nicolas always says: "It's easy when you know the answer!"
Hi Patrice, Raymond and gbinforme
I found the answer to my question; the problem is that there are four merged cells in my row, which prevents the automatic formatting of my row. Thank you anyway for all your responses; nothing is lost or done for nothing in life.
Have a great day
Claude
I found the answer to my question; the problem is that there are four merged cells in my row, which prevents the automatic formatting of my row. Thank you anyway for all your responses; nothing is lost or done for nothing in life.
Have a great day
Claude
Thank you for indicating the origin of your problem.
This is an opportunity to point out to you, as well as to our fellow users of this forum, that operations like hiding a row or a column, merging cells, and even adding borders and fill colors, should always be the very last step in the development of a spreadsheet.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
This is an opportunity to point out to you, as well as to our fellow users of this forum, that operations like hiding a row or a column, merging cells, and even adding borders and fill colors, should always be the very last step in the development of a spreadsheet.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂