Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
\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
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |