Microsoft Excel / Word / Powerpoint --- is it possible to split a table ?

Hopefully a real Excel , word , powerpoint guru can help me with this one ....
One of our Admins is doing a presentation in powerpoint.  Just say for the sake of argument that she needs to import a spreadsheet from Excel.  She wants to know if she can divide the cells (for whatever reason) diagonally so that she can enter a value in each section.  I am assuming it is for presentation value or something ... Is this possible ? Is it possible in Word either ?  I know in powerpoint there are options ( i thought) that on say a pie chart, you can move the line , essentially creating separate pieces.  

Has anyone done this before with Excel or Word ?  If so, can you explain how its done so I can explain to the admin ?
I am wondering also, if its something that has to be done with filemaker pro or pagemaker or something like that ??

Any help is appreciated !!!
dmccormi35Asked:
Who is Participating?
 
Galisteo8Connect With a Mentor Commented:
A workaround may be to use 4 Excel cells instead of 1, for each "split cell" that you want to show in PowerPoint.  Put the "top" data in the upper-right cell, and the "bottom" data in the lower-left; apply the diagonal line to the upper-left and lower-right; then but a border around all 4.  When it pastes into PowerPoint, it would appear to be one cell with two parts.
_______________________
|\                 .                   |
|   \              .                   |
|      \           .                   |
|         \        .     DATA      |
|            \     .                   |
|               \  .                   |
| . . . . . . . . \ . . . . . . . . . .|
|                  .\                  |
|                  .   \               |
|                  .      \            |
|     DATA     .         \         |
|                  .            \      |
|                  .               \   |
|-------------------------------|

Faking it like this, however, may not be practical if you have many such instances where would you need this to be done...

But I'm just thinking off the top of my head.



0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
depends on the version, where in word indeed you can put a diagonal split on a cell.
0
 
dmccormi35Author Commented:
Its MS Small business 2003
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I was just testing out my word and excel, and what you can do is put a diagonal line into the cells, but this does not make it 2 sections. you can write text to the cell, but it does not take care of that line....
0
 
dmccormi35Author Commented:
Gallesteo --- thanks but unfortunately the wanted me to find out if it was possible and "faking" it according to them is not an option since they may need to refer back to those cells or something .... thanks for the thought though :-)
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>since they may need to refer back to those cells or something
you can always give that cell range a name, and refer to those cells by the range name...
0
 
Galisteo8Commented:
Good point, angelIII.

A curious question for dmccormi35, about the users wanting to "point back" to one of these cells (or cell ranges): exactly which of the two values do they want to be the result of such a reference?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.