cell size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robzrob - 14 May 2008 17:27 GMT

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?

Reply to this Message

Teethless mama - 14 May 2008 18:23 GMT

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

Format cells > select Wrap text > OK out

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

Reply to this Message

robzrob - 14 May 2008 21:37 GMT

On May 14, 6:23 pm, Teethless mama
<Teethlessm...@discussions.microsoft.com> wrote:

> It depends how you want it. Either wider column or wider row, or both
>
[quoted text clipped - 5 lines]
>
> - Show quoted text -

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

Reply to this Message

Gord Dibben - 14 May 2008 22:22 GMT

Format>Cells>Alignment>Wrap Text.

Format>Row or Column and "Autofit"

Gord Dibben MS Excel MVP

>On May 14, 6:23 pm, Teethless mama
><Teethlessm...@discussions.microsoft.com> wrote:
[quoted text clipped - 9 lines]
>
>Thanks, but that just makes the text smaller, not the cell bigger :(

Reply to this Message

robzrob - 25 May 2008 16:58 GMT

> Format>Cells>Alignment>Wrap Text.
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Thank you.

Reply to this Message