FormatColumnAutofit or FormatRowAutofit and FornatCellsAlignmentWrap
Text.

Will not expand as you type, only after you hit Enter or Tab or arrow out of
the cell.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 05:24:00 -0700, Shazza wrote:

This just makes my data unreadable, I wanted it to automatically expand as i
typed into the cell. I assume the answer is no as i have tried jsut about
everything that i can think of :(