Auto fit to content

S

Shazza

Is there a way of setting up your worksheet so that the cells expand
automatically to fit the content
 
S

Shazza

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 :(
 
G

Gord Dibben

Format>Column>Autofit or Format>Row>Autofit and Fornat>Cells>Alignment>Wrap
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
 
Top