Auto fit to content

[Shazza]

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

 

[Mike H]

Try,

Format|Cells|Alignment tab
select shrink to fit

Mike

 

[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

 

[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