If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
formatting a cell into triangles
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 |
#3
|
|||
|
|||
formatting a cell into triangles
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 |
#4
|
|||
|
|||
formatting a cell into triangles
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 . |
#5
|
|||
|
|||
formatting a cell into triangles
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 . |
#6
|
|||
|
|||
formatting a cell into triangles
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 . . |
Thread Tools | |
Display Modes | |
|
|