Sheet colum size

[mosmedia]

Is there anyway to make sheet colums longer than one line. I can see they can hold more than one line of information, but they do not expand as i am typeing in information.

Thanks
marc