ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   text wrap is not stable (https://www.excelbanter.com/excel-discussion-misc-queries/192393-text-wrap-not-stable.html)

clara

text wrap is not stable
 
Hi all,

when I change a row's default height to for example 13.50, then the text
wrap does not work.Could you tell me why and how to fix it?

Clara
--
thank you so much for your help

Bob I

text wrap is not stable
 
Text wrap occurs when the cell is high enough to wrap the text to more
than one line. By plugging in your own row high you just killed the auto
height adjustment. To show that text wrap still works, just change the
font to a size 4 and watch it wrap again. So either leave auto height
working or set the needed row height correctly.

clara wrote:

Hi all,

when I change a row's default height to for example 13.50, then the text
wrap does not work.Could you tell me why and how to fix it?

Clara



clara

text wrap is not stable
 
Hi Bob,

Thank you very much. Can I reset the auto heigt ajustment and how. I can not
find font size 4 the smallest is size 8. Why the font size 4 is important
here.?

Clara
--
thank you so much for your help


"Bob I" wrote:

Text wrap occurs when the cell is high enough to wrap the text to more
than one line. By plugging in your own row high you just killed the auto
height adjustment. To show that text wrap still works, just change the
font to a size 4 and watch it wrap again. So either leave auto height
working or set the needed row height correctly.

clara wrote:

Hi all,

when I change a row's default height to for example 13.50, then the text
wrap does not work.Could you tell me why and how to fix it?

Clara




RagDyeR

text wrap is not stable
 
Any manual change will disable the auto-fit feature.

To re-instate it to automatic, from the Menu Bar:
<Format <Row< <AutoFit
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"clara" wrote in message
...
Hi Bob,

Thank you very much. Can I reset the auto heigt ajustment and how. I can not
find font size 4 the smallest is size 8. Why the font size 4 is important
here.?

Clara
--
thank you so much for your help


"Bob I" wrote:

Text wrap occurs when the cell is high enough to wrap the text to more
than one line. By plugging in your own row high you just killed the auto
height adjustment. To show that text wrap still works, just change the
font to a size 4 and watch it wrap again. So either leave auto height
working or set the needed row height correctly.

clara wrote:

Hi all,

when I change a row's default height to for example 13.50, then the text
wrap does not work.Could you tell me why and how to fix it?

Clara






Bob I

text wrap is not stable
 
1. Format, Row, Autofit.
2 You may enter 4 with the keyboard. Size 4, in and of itself is not
important, only that it will fit 2 rows of text into the row height that
you forced.

clara wrote:

Hi Bob,

Thank you very much. Can I reset the auto heigt ajustment and how. I can not
find font size 4 the smallest is size 8. Why the font size 4 is important
here.?

Clara




All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com