cell size

R

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?
 
T

Teethless mama

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

Format cells > select Wrap text > OK out
 
R

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 -
Click to expand...

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

Gord Dibben

Format>Cells>Alignment>Wrap Text.

Format>Row or Column and "Autofit"


Gord Dibben MS Excel MVP
 
Top