Thread: Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C3 C3 is offline
external usenet poster
 
Posts: 13
Default Cell

How to format a cell that depending on amount of text, row will increase its
size or shrink.
Cell contains a formula that depending on result will show 0 (zero) or some
text data (long).


A B
----------------------------------------------------
1 | 0
|
----------------------------------------------------

or

A B
----------------------------------------------------
1 | asjkldfhaksjdh faksjdh flkasjdhflaksjdh |
| lasdjflajksd lfkja sdlkfjalsdkjf laskdjf |
| askdjflaksjdflkajsdlfkjas |
----------------------------------------------------