Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 252
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 252
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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





  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get date/time to wrap (format - wrap text doesn't work)? Alex Excel Discussion (Misc queries) 3 April 4th 23 02:29 PM
Wrap text doesn't wrap [email protected] Excel Worksheet Functions 1 March 28th 07 01:58 AM
Stable formula Syahira New Users to Excel 3 July 28th 06 08:06 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
Stable chart How too create a stable chart? Charts and Charting in Excel 1 January 24th 06 09:34 AM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"