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.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > How to I get into "Properties" for MS Excel labels?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-06-06, 17:08
geoinmesa geoinmesa is offline
Registered User
 
Join Date: Dec 2006
Posts: 2
How to I get into "Properties" for MS Excel labels?

Hello:Everyone!
My problem is that I want to write labels in Excel at an angle. I understand it can be done by getting into properties for labels. I don't know how to do that? Can anyone help me? Thank you

geoinmesa
Reply With Quote
  #2 (permalink)  
Old 12-06-06, 22:16
shades shades is offline
Registered User
 
Join Date: Oct 2003
Posts: 1,091
Howdy and welcome to the board.

What laebls are you referring to? Within Excel or VBA?

Chart labels? Select the x-axis and right-click and choose Format axis. Then select last tab "Alignment". You can enter a degree for angle or click and drag the clock-like icon to whatever angle you want.
__________________
old, slow, and confused
but at least I'm inconsistent!

Rich
(retired Excel 2003 user, 3/28/2008)

How to ask a question on forums
Reply With Quote
  #3 (permalink)  
Old 12-06-06, 23:09
geoinmesa geoinmesa is offline
Registered User
 
Join Date: Dec 2006
Posts: 2
Excel Labels

I am talking about spreadsheet label, not charts. Sorry I didn'nt make it clear. geoinmesa
Reply With Quote
  #4 (permalink)  
Old 12-07-06, 10:04
shades shades is offline
Registered User
 
Join Date: Oct 2003
Posts: 1,091
So, you want the text in a cell set at a specific angle?

Okay, similar process to charts. Select cell(s), right-click and choose Format Cells. Select the second tab (Alignment), then on the right side you can set the degrees by entering a value. Or on the icon, click the red diamond and drag it to the position you want.
__________________
old, slow, and confused
but at least I'm inconsistent!

Rich
(retired Excel 2003 user, 3/28/2008)

How to ask a question on forums
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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