How do I turn cells to a 45-degree angle?

[Guest]

I'm trying to rotate the cells (not just the text in the cells) to a
45-degree angle. I've done this in past versions of Excel, but I can't find
it in Excel XP (2003?)

 

[Chip Pearson]

Go to the Format menu, choose Cell and then the Alignment tab.
There, adjust the Orientation control to suit your needs.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Roger Govier]

Hi

Having rotated your text to 45 degrees, give the cells a Border and that
will be angled as well.

Regards

Roger Govier

 

[Guest]

I am having the same problem. I tried Format->Alignment, but all I get is a
square cell with my text going diagonal. What I want is a diagonal text in a
diagonal cell. I am having the same problem in Excel 2000 and 2003. Any
other suggestions? Thanks.

 

[Desert Piranha]

I am having the same problem. I tried Format->Alignment, but all I ge
is a
square cell with my text going diagonal. What I want is a diagona
text in a
diagonal cell. I am having the same problem in Excel 2000 and 2003.
Any
other suggestions? Thanks.

You can't rotate the cells. You can only give the illusion they ar
rotated. Rogers solution works fine for me

 

[Guest]

Following up a relatively old post:

That's fine, but is it possible to have angled text and a straight border?
I'm trying to create a two-line table, with v large fonts in Line 1 and
smaller text in Line 2. In past versions of Excel, I think I've been able to
have the angle/straight mix.

 

[Gord Dibben]

David

No version of Excel has allowed a user to physically rotate/angle a cell.

You may have seen what you thought was an angled cell but cannot be done.

You can make the cell appear slanted by slanting the text to 45 degrees or
whatever you like and placing borders around the cell and increasing the row
height.

Adding a background color gives an added touch.

BUT.......the cell is still rectangular which you will see when you select it.


Gord Dibben MS Excel MVP

 

[azinger158]

You have to go into the alignment and then also into the border tab. once there make sure you click on the outline and have your text wrapped.