Solved

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

Posted on 2006-07-07
7
3,070 Views
Last Modified: 2010-08-05
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 !!!
0
Comment
Question by:dmccormi35
  • 3
  • 2
  • 2
7 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17062048
depends on the version, where in word indeed you can put a diagonal split on a cell.
0
 

Author Comment

by:dmccormi35
ID: 17064917
Its MS Small business 2003
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17065892
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 8

Accepted Solution

by:
Galisteo8 earned 400 total points
ID: 17067900
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
 

Author Comment

by:dmccormi35
ID: 17073190
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
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 100 total points
ID: 17074365
>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
 
LVL 8

Expert Comment

by:Galisteo8
ID: 17102867
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

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question