| View previous topic :: View next topic |
| Author |
Message |
canduc17
General User
Joined: 06 Sep 2006
Posts: 10
Location: Bologna (Italy)
|
 Posted: Fri Sep 14, 2007 1:47 am Post subject: Text in merged cells [Solved] |
 |
|
Hi Everybody.
That's my problem: I have merged 5 cells in a vertical way (A1,A2,A3,A4,A5).
So I have obtained a rectangle.
How can I do to put some text in the center of this rectangle?
Thank you...
_________________
Bella te! (Typical italian-near Bologna greeting)
Last edited by canduc17 on Fri Sep 14, 2007 3:55 am; edited 1 time in total |
|
| Back to top |
|
 |
Lek
Power User
Joined: 20 Oct 2006
Posts: 73
|
| Posted: Fri Sep 14, 2007 2:24 am Post subject: |
|
|
This works for me.....
Select merged cell.
Format > Cells
Open Alignment Tab
Under Horizontal: Center
Under Vertical: Middle |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Sep 14, 2007 3:25 am Post subject: |
|
|
B1: =A1&" "&A2&" "&A3&" "&A4&" "&A5
Select B1:B5
Format>Merge
Now you have the merged values in B, editable in A. |
|
| Back to top |
|
|
canduc17
General User
Joined: 06 Sep 2006
Posts: 10
Location: Bologna (Italy)
|
| Posted: Fri Sep 14, 2007 3:54 am Post subject: |
|
|
It works perfectly, thank you very much guys!
_________________
Bella te! (Typical italian-near Bologna greeting) |
|
| Back to top |
|
|
|
