Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I shuffle a group of cells randomly in Excel? | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |