Wrapping Text
I selected wrap text, but Excel isnt showing all the contents of the cell
until I change the vertical height of the cell manually. It used to do this automatically. Can anyone help me? |
Is that a merged cell?
If yes, the autofitting the rowheight won't work. Have you changed the rowheight manually? If yes, then excel will respect that setting until you autofit the rowheight once more. Confused wrote: I selected wrap text, but Excel isnt showing all the contents of the cell until I change the vertical height of the cell manually. It used to do this automatically. Can anyone help me? -- Dave Peterson |
Hello-
Excel will automatically adjust the row height if it has not already been manually adjusted. Excel apparently believes that if you set a row height to something other than the default, that you want the row to stay at that height unless you change it yourself. If you select the area involved and go to FormatRowAutofit it should fix the problem. BTW- Column width works the same way... unchanged columns will automatically adjust when you apply number formatting, but only if you have not previously changed the width of the column. HTH |:) "Confused" wrote: I selected wrap text, but Excel isnt showing all the contents of the cell until I change the vertical height of the cell manually. It used to do this automatically. Can anyone help me? |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com