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 |
<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 |
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 |
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 |
All times are GMT +1. The time now is 10:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com