Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


photo_angel2004 Wrote:
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.:)Hi photo,


See if this helps.
http://office.microsoft.com/en-us/as...097991033.aspx


--
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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


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 have
what I was looking for I already have the step by step microsoft office
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 Out
by Craig Stinson and Mark


Thank you again!

:)


--
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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


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


--
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

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


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



  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How can I create slanted headers?


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.


Thanks


--
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

  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,688
Default How can I create slanted headers?

Hi!

Select the cell(s) in question.
Goto the menu FormatCellsAlignment 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"
<photo_angel2004.2c7bf8_1155006914.7723@excelfor um-nospam.com wrote in
message news:photo_angel2004.2c7bf8_1155006914.7723@excelf orum-nospam.com...

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Automatically Create Scatter Plot Charts Chris Gregory Charts and Charting in Excel 8 October 13th 06 03:35 AM
quickly create extra copies of a worksheet template in a workbook simon Excel Worksheet Functions 2 October 23rd 05 07:04 PM
need to create a formula to create a timesheet but haven't a clue AHurd Excel Discussion (Misc queries) 7 August 22nd 05 12:04 PM
Create a tabular control rkg Excel Discussion (Misc queries) 0 August 8th 05 09:25 PM
Headers on every worksheet lockwood33 Excel Worksheet Functions 1 July 8th 05 07:17 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"