formatting a cell into triangles

Hello,

Can anyone suggest a way of formatting a cell so that when it prints it has
a diagonal line from the bottom left corner to the top right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K

Format|Cells
Open Border tab, locate diagonal line and click
Done
Best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"KK" wrote in message
...
Hello,

Can anyone suggest a way of formatting a cell so that when it prints it
has
a diagonal line from the bottom left corner to the top right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K

Do just as Bernard says, and you will get your diagonal line..........you
might also want to do the "Outline" at the same time and here you also get
your choice of Line Weight and Color............and, if this is something
you would want to do frequently, you could record a macro to perofrm these
operatins to any selected cell, or group of selected cells.


Vaya con Dios,
Chuck, CABGx3


"KK" wrote in message
...
Hello,

Can anyone suggest a way of formatting a cell so that when it prints it
has
a diagonal line from the bottom left corner to the top right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K

Hi KK
Just a bit more on Chuck and Bernards info.....
If you want to put info in both triangles, type your text
in the top triangle, then press ALT + Enter, hit space
about 5 or 6 times and then type your info in the bottom
triangle.
Regards
Michael
-----Original Message-----
Hello,

Can anyone suggest a way of formatting a cell so that
when it prints it has
a diagonal line from the bottom left corner to the top
right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K


.

That is coool Michael...........another trick for my personal
goodie-box.......thanks

Vaya con Dios,
Chuck, CABGx3

"Michael" wrote in message
...
Hi KK
Just a bit more on Chuck and Bernards info.....
If you want to put info in both triangles, type your text
in the top triangle, then press ALT + Enter, hit space
about 5 or 6 times and then type your info in the bottom
triangle.
Regards
Michael
-----Original Message-----
Hello,

Can anyone suggest a way of formatting a cell so that
when it prints it has
a diagonal line from the bottom left corner to the top
right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K


.

My Pleasure Chuck

What goes round comes round

Regards
Michael
-----Original Message-----
That is coool Michael...........another trick for my
personal
goodie-box.......thanks

Vaya con Dios,
Chuck, CABGx3

"Michael" wrote in
message
...
Hi KK
Just a bit more on Chuck and Bernards info.....
If you want to put info in both triangles, type your
text
in the top triangle, then press ALT + Enter, hit space
about 5 or 6 times and then type your info in the bottom
triangle.
Regards
Michael
-----Original Message-----
Hello,

Can anyone suggest a way of formatting a cell so that
when it prints it has
a diagonal line from the bottom left corner to the top
right, effectively
splitting the cell into 2 triangles!

thanks for all ideas

K


.



.