Why doesn't Excel "word wrap" always expand the cell fully?
 

I work with fairly lengthy & wordy Excel spreadsheets that frequently need
additional information in the cells . Sometimes the cells do not expand to
display all the text contained therein. Usually , with the cell highlighted ,
by pulldown Format then Cells and selecting the Alignment tab in Text
Control turning on & off Word Wrap will correct this.
The cell expands in size making all the text visible.
Other times , the Row may have to be highlighted.
Other times merely changing the cell & pressing enter will enable the full
display.
Yet , other times...the most frustrating ones...nothing short of manually
setting the height of the row , will allow automatic word wrap display.
I must be missing something...or it is just another bug.

Why doesn't Excel "word wrap" always expand the cell fully?
 

If you've ever changed the rowheight manually, the excel figures it shouldn't
adjust the rowheight.

You can autofit that row and things should be back to normal.

But if you use merged cells, autofitting of rows is a problem.



prettyb wrote:

I work with fairly lengthy & wordy Excel spreadsheets that frequently need
additional information in the cells . Sometimes the cells do not expand to
display all the text contained therein. Usually , with the cell highlighted ,
by pulldown Format then Cells and selecting the Alignment tab in Text
Control turning on & off Word Wrap will correct this.
The cell expands in size making all the text visible.
Other times , the Row may have to be highlighted.
Other times merely changing the cell & pressing enter will enable the full
display.
Yet , other times...the most frustrating ones...nothing short of manually
setting the height of the row , will allow automatic word wrap display.
I must be missing something...or it is just another bug.

--

Dave Peterson