View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Using autofit on cells which include ASCII 10 (LF) character

Auto fit the rows

"DartGuru" wrote:

I use MS Excel 2003 SP2.

I have cells which include the line feed character ASC 10.
So a cell might contain four lines of text (with three LFs).

When I use autofit, either coded or double-clicking on the horizontal
row separator, the row reduces to the width of a single row of text,
such that the remaining three rows are not visible.

Is there a way around this ?