Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
asd987
 
Posts: n/a
Default 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


  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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

  #3   Report Post  
swisse
 
Posts: n/a
Default

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
  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I shuffle a group of cells randomly in Excel? golfmoab Excel Discussion (Misc queries) 1 January 22nd 05 01:08 PM
Adding formatted cells to an outline ? Glenn Excel Discussion (Misc queries) 4 January 11th 05 04:10 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"