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
|
|||
|
|||
Need to angle the borders in a column
Don't know how to slant the borders in a column. Don't want the line that
runs through the middle. Want the side borders to angle at 60 degrees if possible. Know it can be done just not sure how. |
#2
|
|||
|
|||
Need to angle the borders in a column
Take a look at the dialog box that comes up with Format Cells. Go to
the Border tab and look at the bottom left & right corners of the 'Border Box' where you should see little boxes with diagonal lines in them. Do they give you what you want? Rgds, ScottO "Kasper" wrote in message ... | Don't know how to slant the borders in a column. Don't want the line that | runs through the middle. Want the side borders to angle at 60 degrees if | possible. Know it can be done just not sure how. |
#3
|
|||
|
|||
Need to angle the borders in a column
Here is what is in Help for Excel. Are you trying to angle the borders without angling the text because the following method slants both text and borders? APPLY ANGLED TEXT AND BORDERS 1. Select the cells you want to format. 2. On the *Format* menu, click *Cells*. 3. On the *Border* tab, apply vertical borders to the left, right, and middle of the range. 4. On the *Alignment* tab, in the *Orientation* box, click a degree point, or drag the indicator to the angle you want. *Note* It's usually best to select a positive angle between 30 and 60 degrees. 5. Under *Text alignment*, in the *Horizontal* list box, click *Center*, and then click *OK*. Excel rotates the left and right borders along with the text. 6. To shrink all the columns to their smallest possible width, select them, point to *Column* On the *Format* menu, and then click *AutoFit Selection*. ScottO Wrote: Take a look at the dialog box that comes up with Format Cells. Go to the Border tab and look at the bottom left & right corners of the 'Border Box' where you should see little boxes with diagonal lines in them. Do they give you what you want? Rgds, ScottO "Kasper" wrote in message ... | Don't know how to slant the borders in a column. Don't want the line that | runs through the middle. Want the side borders to angle at 60 degrees if | possible. Know it can be done just not sure how. -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=496575 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Using angled column headings and borders | Lisa H | General Discussion | 3 | July 5th, 2005 04:30 PM |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
Return Count for LAST NonBlank Cell in each Row | Sam via OfficeKB.com | Worksheet Functions | 12 | April 17th, 2005 10:36 PM |
up to 7 functions? | ALex | Worksheet Functions | 10 | April 12th, 2005 06:42 PM |