Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I turn cells to a 45-degree angle?
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?) |
#2
|
|||
|
|||
How do I turn cells to a 45-degree angle?
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 "WJason" wrote in message ... 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?) |
#3
|
|||
|
|||
How do I turn cells to a 45-degree angle?
Hi
Having rotated your text to 45 degrees, give the cells a Border and that will be angled as well. Regards Roger Govier WJason wrote: 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?) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn cells to a 45-degree angle?
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. "Roger Govier" wrote: Hi Having rotated your text to 45 degrees, give the cells a Border and that will be angled as well. Regards Roger Govier WJason wrote: 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?) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn cells to a 45-degree angle?
alibild Wrote: 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. "Roger Govier" wrote: Hi Having rotated your text to 45 degrees, give the cells a Border and that will be angled as well. Regards Roger Govier WJason wrote: 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?) WJason, You can't rotate the cells. You can only give the illusion they are rotated. Rogers solution works fine for me. -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=480627 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn cells to a 45-degree angle?
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. "Roger Govier" wrote: Hi Having rotated your text to 45 degrees, give the cells a Border and that will be angled as well. Regards Roger Govier WJason wrote: 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?) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn cells to a 45-degree angle?
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 On Mon, 14 May 2007 02:52:00 -0700, David M Hargrave wrote: 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?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
How do I "turn off" cells so they are not included in autosum | Excel Worksheet Functions |