cell size

[robzrob]

If I've got a cell where text is to be entered but I don't know how
much, can I set the cell's height (or width) to increase according to
the amount of text typed into it?

 

[Teethless mama]

It depends how you want it. Either wider column or wider row, or both

Format cells > select Wrap text > OK out

 

[robzrob]

It depends how you want it. Either wider column or wider row, or both

Format cells > select Wrap text > OK out





- Show quoted text -

Thanks, but that just makes the text smaller, not the cell bigger

 

[Gord Dibben]

Format>Cells>Alignment>Wrap Text.

Format>Row or Column and "Autofit"


Gord Dibben MS Excel MVP

 

[robzrob]

Format>Cells>Alignment>Wrap Text.

Format>Row or Column and "Autofit"

Gord Dibben  MS Excel MVP






- Show quoted text -

Thank you.