View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Brock Brock is offline
external usenet poster
 
Posts: 6
Default Wrapping Text and Cell Expansion

What if the columns in the row are merged?

"RagDyer" wrote:

First of all, make sure the cell is not 'merged'.

Next, if you, at any time, manually adjusted the height of the row,
"auto-fit" becomes disabled.

To re-set it to automatic, try:
<Format <Row <Auto-Fit
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Brock" wrote in message
...
When a cell is formatted to wrap text and the text takes up more than a
single row how do I get the row to automatically expand vertically to
accomodate the text?