Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Wrap text doesn't wrap | Excel Worksheet Functions | |||
Stable formula | New Users to Excel | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Stable chart | Charts and Charting in Excel |