Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
I have orientated (rotated) text by the orientation dial by 90 degrees. The
headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
Hi Stan
What happens if you make the row deeper? Do you mean rotating by 90 degrees, or 45 degrees? I have seldom had problems with 90 degree rotation. With 45 degree, apply borders to the cells and that usually helps. -- Regards Roger Govier "StanTheManII" wrote in message ... I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
How about merging the cells as well as rotating them?
-- Thanks, Shane Devenshire "StanTheManII" wrote: I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
I have tried everything, even our excel expert is stumped. I think its a
bug, and should probably report it to microsoft. Just try a 17 (3 word) text "the cat sat on the mat and the dog ran over the cat with a car" or try a text "Compressed Available Dispicable incapable destitute overwhelming" see how the wrap is incorrect. You'll see the words missing. We've tried several computers now an all exhibit the same problem. "Roger Govier" wrote: Hi Stan What happens if you make the row deeper? Do you mean rotating by 90 degrees, or 45 degrees? I have seldom had problems with 90 degree rotation. With 45 degree, apply borders to the cells and that usually helps. -- Regards Roger Govier "StanTheManII" wrote in message ... I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
Hi Stan
What version of Excel are you using? I don't get any problem with the 2 sample texts you provided, In Xl2003 or XL2007. At 90 degree no problem at all. At 45 degree, Ok once borders added to cells. -- Regards Roger Govier "StanTheManII" wrote in message ... I have tried everything, even our excel expert is stumped. I think its a bug, and should probably report it to microsoft. Just try a 17 (3 word) text "the cat sat on the mat and the dog ran over the cat with a car" or try a text "Compressed Available Dispicable incapable destitute overwhelming" see how the wrap is incorrect. You'll see the words missing. We've tried several computers now an all exhibit the same problem. "Roger Govier" wrote: Hi Stan What happens if you make the row deeper? Do you mean rotating by 90 degrees, or 45 degrees? I have seldom had problems with 90 degree rotation. With 45 degree, apply borders to the cells and that usually helps. -- Regards Roger Govier "StanTheManII" wrote in message ... I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
I'm using 2003 (11.8211.8292) SP3. The monitor is a widescreen. It does it
on several computers! The word wrap cuts of part of the information. I tried putting a border around it, didn't cure it. Tnx DavidAB "Roger Govier" wrote: Hi Stan What version of Excel are you using? I don't get any problem with the 2 sample texts you provided, In Xl2003 or XL2007. At 90 degree no problem at all. At 45 degree, Ok once borders added to cells. -- Regards Roger Govier "StanTheManII" wrote in message ... I have tried everything, even our excel expert is stumped. I think its a bug, and should probably report it to microsoft. Just try a 17 (3 word) text "the cat sat on the mat and the dog ran over the cat with a car" or try a text "Compressed Available Dispicable incapable destitute overwhelming" see how the wrap is incorrect. You'll see the words missing. We've tried several computers now an all exhibit the same problem. "Roger Govier" wrote: Hi Stan What happens if you make the row deeper? Do you mean rotating by 90 degrees, or 45 degrees? I have seldom had problems with 90 degree rotation. With 45 degree, apply borders to the cells and that usually helps. -- Regards Roger Govier "StanTheManII" wrote in message ... I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rotating Text
Sorry Stan, I'm out of ideas.
As I said, it works fine for me. -- Regards Roger Govier "StanTheManII" wrote in message ... I'm using 2003 (11.8211.8292) SP3. The monitor is a widescreen. It does it on several computers! The word wrap cuts of part of the information. I tried putting a border around it, didn't cure it. Tnx DavidAB "Roger Govier" wrote: Hi Stan What version of Excel are you using? I don't get any problem with the 2 sample texts you provided, In Xl2003 or XL2007. At 90 degree no problem at all. At 45 degree, Ok once borders added to cells. -- Regards Roger Govier "StanTheManII" wrote in message ... I have tried everything, even our excel expert is stumped. I think its a bug, and should probably report it to microsoft. Just try a 17 (3 word) text "the cat sat on the mat and the dog ran over the cat with a car" or try a text "Compressed Available Dispicable incapable destitute overwhelming" see how the wrap is incorrect. You'll see the words missing. We've tried several computers now an all exhibit the same problem. "Roger Govier" wrote: Hi Stan What happens if you make the row deeper? Do you mean rotating by 90 degrees, or 45 degrees? I have seldom had problems with 90 degree rotation. With 45 degree, apply borders to the cells and that usually helps. -- Regards Roger Govier "StanTheManII" wrote in message ... I have orientated (rotated) text by the orientation dial by 90 degrees. The headings I have in these cells are about 30 letters long. When I rotate the text is causes the text to run into each other. Words later in the text appear within the previous text in the cell and is undreadable. It also trunkates the words at the "word wrap" area removing 2 letters of each word at the word wrap zone. I am using Arial 10, athough I've tried other fonts. Using long words exaserbates the problem. Any ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rotating data | Excel Discussion (Misc queries) | |||
rotating a spreadsheet | Excel Discussion (Misc queries) | |||
rotating list | Excel Worksheet Functions | |||
While rotating object, how to rotate the text inside - in excel | Excel Discussion (Misc queries) | |||
Rotating Scroll Bar | Excel Discussion (Misc queries) |