ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   define group of cells (https://www.excelbanter.com/excel-discussion-misc-queries/4492-define-group-cells.html)

asd987

define group of cells
 
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 ,
"asd987" 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" 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




All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com