creating angled lines for column 'titles'

AwfulSara · Apr 24th, 2002, 04:31 PM

Rather hard to describe well what I need... I'm creating a table with column widths of 10 or so. I need to label each column head with several words (about 20 character max) which will not fit on the narrow width columns. I need to know how to create angled lines at the head of each column on which text can be typed at the same angle, on or above the angled lines. Then the text I need will fit in the width I want, and look neat as well. Simple question I think, I'm just not as well-versed in Excel as I would like! Thanks!!

Mark W. · Apr 24th, 2002, 04:34 PM

Select your headers, choose the Format | Cells... menu command (or Control+1), click on the Alignment tab, drag the orientation dial to the desired position or enter the desired degree (e.g., 45) value. Click on the Borders tab and apply them if desired.

[ This Message was edited by: Mark W. on 2002-04-24 15:38 ]

NateO · Apr 24th, 2002, 04:37 PM

For the lines, you can either choose to "Underline" the text (U) (not cell underline border, although a complete cell border seems to angle...

) or draw in your very own lines. See Insert->Picture->AutoShapes. Click on the left-most icon and you're ready for custom lines.

_________________
Cheers, NateO
"Me no are no nice guy."

[ This Message was edited by: NateO on 2002-04-24 15:49 ]

Apr 24th, 2002, 04:37 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	For the lines, you can either choose to "Underline" the text (U) (not cell underline border, although a complete cell border seems to angle...) or draw in your very own lines. See Insert->Picture->AutoShapes. Click on the left-most icon and you're ready for custom lines. _________________ Cheers, NateO "Me no are no nice guy." [ This Message was edited by: NateO on 2002-04-24 15:49 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 04:31 PM	#1
AwfulSara New Member Join Date: Apr 2002 Location: San Luis Obispo, CA Posts: 1	Rather hard to describe well what I need... I'm creating a table with column widths of 10 or so. I need to label each column head with several words (about 20 character max) which will not fit on the narrow width columns. I need to know how to create angled lines at the head of each column on which text can be typed at the same angle, on or above the angled lines. Then the text I need will fit in the width I want, and look neat as well. Simple question I think, I'm just not as well-versed in Excel as I would like! Thanks!!

Apr 24th, 2002, 04:34 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Select your headers, choose the Format \| Cells... menu command (or Control+1), click on the Alignment tab, drag the orientation dial to the desired position or enter the desired degree (e.g., 45) value. Click on the Borders tab and apply them if desired. [ This Message was edited by: Mark W. on 2002-04-24 15:38 ]