Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text diagonal
Occasionally I need to put big color text, something like: "PAID" or
"CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS. How can I put it diagonally rather than only horizontally or vertically. Thanks. |
#2
|
|||
|
|||
hi,
formatcellsallignment taborientatins box adjust the spin button up to 45 degrees. Regards FSt1 "Sunantoro" wrote: Occasionally I need to put big color text, something like: "PAID" or "CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS. How can I put it diagonally rather than only horizontally or vertically. Thanks. |
#3
|
|||
|
|||
You can tilt the text within a cell, (Format Cell, Alignment, tilt) but in the case you are asking I think you would be meaning a Watermark, for which you could start at http://tinyurl.com/9h5gr a posting courtesy of Ron de Bruin on Oct 12 2004 Sunantoro Wrote: Occasionally I need to put big color text, something like: "PAID" or "CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS. How can I put it diagonally rather than only horizontally or vertically. Thanks. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=399010 |
#4
|
|||
|
|||
I used to use wordart (from the drawing toolbar) to do this sort of thing. You can resize it, colour it, change the outline etc. to suit your needs. -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=399010 |
#5
|
|||
|
|||
One way
Right click on a blank area of your Toolbar, and select the WordArt toolbar. Click on the large "A" at the left of the bar and select the type you prefer, (the first one is quite suitable)a nd press enter. Type in PAID, set Font size to whatever size you want and OK. Drag to the desired position and use the Rotate handle to to the desired angle. -- Regards Roger Govier "Sunantoro" wrote in message ... Occasionally I need to put big color text, something like: "PAID" or "CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS. How can I put it diagonally rather than only horizontally or vertically. Thanks. |
#6
|
|||
|
|||
To my surprise that most of my questions have been questioned and answered in
various other discussions. The Nice thing is that there are always people who are willing to direct me to those discussion sites. Thanks gentlemen! SUNAN "Sunantoro" wrote: Occasionally I need to put big color text, something like: "PAID" or "CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS. How can I put it diagonally rather than only horizontally or vertically. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |