define group of cells

[asd987]

Hello,

Because of the lay out of my sheet I want to use a group of cells (d3:h8) as
one textfield. Is there a possibility to configure the cells so I can type
the text which is then displayed in the whole range (d3:h8)?

Thanks,

Sjoerd

[JE McGimpsey]

Merge the cells...

In article <[email protected]>,
"asd987" <[email protected]> wrote:

> Hello,
>
> Because of the lay out of my sheet I want to use a group of cells (d3:h8) as
> one textfield. Is there a possibility to configure the cells so I can type
> the text which is then displayed in the whole range (d3:h8)?
>
> Thanks,
>
> Sjoerd

[swisse]

Hello Sjoerd,
If you want to define a group of cells select first the cells you want to
define in a range, click in the Name box which is the box to left of the
formula bar, and then type the name for that range then press Enter.

Swisse

[Myrna Larson]

I wouldn't merge the cells. That often creates more problems than it solves.
Another way is to start typing the text in D3 down through D8. Then select
D3:H8 and Edit/Fill/Justify. This will reformat the text to fill this area.


On Sun, 23 Jan 2005 13:38:36 +0100, "asd987" <[email protected]> wrote:

>Hello,
>
>Because of the lay out of my sheet I want to use a group of cells (d3:h8) as
>one textfield. Is there a possibility to configure the cells so I can type
>the text which is then displayed in the whole range (d3:h8)?
>
>Thanks,
>
>Sjoerd
>