Hello,
At work today I was asked to create a spread sheet with products an
they want the colums on the top to say the name of the product in
slanted lined format. I am not sure what this is called and I am no
sure how to explain it with out showing what I mean.

But instead if striaght up and down lines on the top the need to b
slanted on an angel when you type the text in the texts types straigh
accrossed but when you are done typing it goies up on that angle in th
lines. I have been pulling my hair out trying to figure out how to d
this. I have a few books on excel yet I can not find the answer.

Any help would be wonderful.:

--
photo_angel200
-----------------------------------------------------------------------
photo_angel2004's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

photo_angel2004 Wrote:
> Hello,
> At work today I was asked to create a spread sheet with products an
> they want the colums on the top to say the name of the product in
> slanted lined format. I am not sure what this is called and I am no
> sure how to explain it with out showing what I mean.
>
> But instead if striaght up and down lines on the top the need to b
> slanted on an angel when you type the text in the texts types straigh
> accrossed but when you are done typing it goies up on that angle in th
> lines. I have been pulling my hair out trying to figure out how to d
> this. I have a few books on excel yet I can not find the answer.
>
> Any help would be wonderful.Hi photo,

See if this helps.
http://office.microsoft.com/en-us/as...1097991033.asp

--
Desert Piranh

-----------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

yes that is a big help thank you very much.

I was looking at this book a week ago but I wasnt sure if it would hav
what I was looking for I already have the step by step microsoft offic
system and the step by step excel but that info isnt in those books.


I just may have to buy this one:

This article is excerpted from Microsoft Office Excel 2003 Inside Ou
by Craig Stinson and Mark


Thank you again!

:

--
photo_angel200
-----------------------------------------------------------------------
photo_angel2004's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

Hi!

Select the cell(s) in question.
Goto the menu Format>Cells>Alignment tab
On the right side you'll see Orientation
Either "grab" the dial with your mouse and drag to the desired angle or use
the spinner buttons.

Biff

"photo_angel2004"
<(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> Hello,
> At work today I was asked to create a spread sheet with products and
> they want the colums on the top to say the name of the product in a
> slanted lined format. I am not sure what this is called and I am not
> sure how to explain it with out showing what I mean.
>
> But instead if striaght up and down lines on the top the need to be
> slanted on an angel when you type the text in the texts types straight
> accrossed but when you are done typing it goies up on that angle in the
> lines. I have been pulling my hair out trying to figure out how to do
> this. I have a few books on excel yet I can not find the answer.
>
> Any help would be wonderful.
>
>
> --
> photo_angel2004
> ------------------------------------------------------------------------
> photo_angel2004's Profile:
> http://www.excelforum.com/member.php...o&userid=37213
> View this thread: http://www.excelforum.com/showthread...hreadid=569292
>

Ok now I can get the line but I cant get the text to go with them th
text is all over the place. :confused

--
photo_angel200
-----------------------------------------------------------------------
photo_angel2004's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

photo_angel2004 Wrote:
> Ok now I can get the line but I cant get the text to go with them the
> text is all over the place. Hi Photo,
That isn't very informative.

Just do what Biff said or read the link and apply a border to the
cells.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=569292

thats not working here though I can get the slanted lines.... that par
is good.

I can not get the text to match it though.

The text needs to be centered and the text is all over the place o
slanted but not centered in the lines and doesnt match the lines. I a
lost.


Thank

--
photo_angel200
-----------------------------------------------------------------------
photo_angel2004's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

photo_angel2004 Wrote:
> thats not working here though I can get the slanted lines.... that part
> is good.
>
> I can not get the text to match it though.
>
> The text needs to be centered and the text is all over the place or
> slanted but not centered in the lines and doesnt match the lines. I am
> lost.
>
>
> ThanksHi photo,

Maybe your row height needs to be adjusted.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=569292

no that is not working if I ajust the size of the cells the text get
worse not better.

I dont know how to explaine this without a screen shot.


On the top of each colum I need the header lines to be slanted.... tha
part I can get. I can not get the text to match it though. the text i
either right on the line to the left or the text is all over the plac
I can not get it centered inbtween the Slanted lines, it seems t
center from the center of the cell and not inbtween the slanted lines.
There are a lot of settings I have tried them all and moved the cell
longer and shorted only for the text to appear worse.

I just can not seem to get it to look like the one in the picture o
that link in the first reply.

What am I doing wrong?

Thanks

What I am shooting for is the Middle pic on this link:

http://office.microsoft.com/en-us/as...1097991033.asp

--
photo_angel200
-----------------------------------------------------------------------
photo_angel2004's Profile: http://www.excelforum.com/member.php...fo&userid=3721
View this thread: http://www.excelforum.com/showthread.php?threadid=56929

photo_angel2004 Wrote:
> no that is not working if I ajust the size of the cells the text gets
> worse not better.
>
> I dont know how to explaine this without a screen shot.
>
>
> On the top of each colum I need the header lines to be slanted.... that
> part I can get. I can not get the text to match it though. the text is
> either right on the line to the left or the text is all over the place
> I can not get it centered inbtween the Slanted lines, it seems to
> center from the center of the cell and not inbtween the slanted lines.
> There are a lot of settings I have tried them all and moved the cells
> longer and shorted only for the text to appear worse.
>
> I just can not seem to get it to look like the one in the picture of
> that link in the first reply.
>
> What am I doing wrong?
>
> Thanks
>
> What I am shooting for is the Middle pic on this link:
>
> http://office.microsoft.com/en-us/as...7991033.aspxHi photo,

Ok so you have the borders correct right?

The text format you don't have any wrap or something like that do you?

Try again.
Select the cells you are using then;
Go to Format>Alignment>

Horizontal should be >Center
Vertical should be >Center
The angle should be pointing up (not down) at about 45 degrees
No Wrap,Merge, Or Shrink should be ticked.

How does that work?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=569292