Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text writign in merged rows
\sometimes, I merge several rows and write my comments.
Let's say. three rows are merged to form a big box. When I write texts, it starts from the bottom of the merged box (i.e., row). I could not figure out how to write texts from the top of the merged box. Regards, Craig |
#2
|
|||
|
|||
<Format <Cells <Alignment tab,
Expand the "Vertical" box and choose "Top". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "macho" wrote in message ... \sometimes, I merge several rows and write my comments. Let's say. three rows are merged to form a big box. When I write texts, it starts from the bottom of the merged box (i.e., row). I could not figure out how to write texts from the top of the merged box. Regards, Craig |
#3
|
|||
|
|||
Click Format Cells Alignment tab
Make the settings as: Horizontal: Left (Indent) Vertical: Top Click OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "macho" wrote in message ... \sometimes, I merge several rows and write my comments. Let's say. three rows are merged to form a big box. When I write texts, it starts from the bottom of the merged box (i.e., row). I could not figure out how to write texts from the top of the merged box. Regards, Craig |
#4
|
|||
|
|||
Thanks Raddyer,
That was a pain all my life. The problem was now solved. Thanks again. Craig "Ragdyer" wrote in message ... <Format <Cells <Alignment tab, Expand the "Vertical" box and choose "Top". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "macho" wrote in message ... \sometimes, I merge several rows and write my comments. Let's say. three rows are merged to form a big box. When I write texts, it starts from the bottom of the merged box (i.e., row). I could not figure out how to write texts from the top of the merged box. Regards, Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieve text from merged cells | Excel Worksheet Functions | |||
Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
Totaling rows of text | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |