PC Review


Reply
Thread Tools Rate Thread

"Diagonal" cells - text-wrapping question

 
 
Peter
Guest
Posts: n/a
 
      8th Mar 2011
Hi. I'm doing a tricky poor-man's-Illustrator project with Excel
2007. I'm trying to create the impression of a large cell that's been
split in half diagonally (with a diagonal ascending from bottom left
to top right). I've created a 2 x 2 grid of cells and put a diagonal
border through the lower left and top right cells and removed the
vertical, internal borders. Looks great so far. In addition, I'd
like to place text in the upper left and lower right cells. Ideally,
this text would be wider than the upper left or lower right cell and
would flow over into the adjacent cell, but not so far as to impinge
on the diagonal border. This seems to work if I only add one line of
text - but if I include an ALT-ENTER in either cell, in order to add a
second line of text, Excel seems to automatically change the
formatting of that cell to "Wrap Text". Is there a workaround? I
hope this question is clear, it's a bit murky...

Thanks very much.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
No "Text wrapping break" option =?Utf-8?B?QmlnLUQ=?= Microsoft Word Document Management 1 3rd May 2007 11:28 AM
Text does not display in "Text boxs" and when wrapping text in a c =?Utf-8?B?RXN0ZWJhbg==?= Microsoft Excel Misc 1 8th Mar 2007 11:59 PM
How do I control the "text wrapping" setting for plain text? =?Utf-8?B?U3RhbmxleQ==?= Microsoft Outlook Discussion 0 13th May 2005 09:25 AM
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? =?Utf-8?B?Ni1zaG9vdGVy?= Microsoft Excel Worksheet Functions 3 31st Oct 2004 12:14 AM
Sum a range of cells with without the first character "text" & "numerical" John Microsoft Excel Worksheet Functions 5 12th Sep 2004 07:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:26 AM.