Diagonally Dividing Individual Cell


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
how could divide one single cell in diagonal direction ?? without using line from drawing tool.
Similar Excel Video Tutorials
Names Cell If Name in Cell
 See how to name individual cells a name that is the cell content (the name of the cell is in the cell). To do this: 1) Put names in column B, 2) copy ...
Multiplying & Dividing Fractions
 See how to multiply and Divide Fractions using Excel
Key Points:
1.Multiplying fractions less than one will always result in a number less t ...
Similar Topics
How do I paste text from a column into a diagonal line of cells (i.e. A1, B2,
C3, etc.)? Additionally (and this may be related), how do I get the cursor
to move to a diagonal cell after an entry? (as opposed to down or to the side)
I am creating a report that has to show the number of new customers and the dollar value those customers brought in. We would like to have the cell appear with a diagonal split so the # of new customers is in the top left and the $ is at the bottom right with a diagonal line between the two. Is this possible? if so, how can I do this?
Steps to duplicate:
(1) Draw a new forms button in Cell A8
(2) Format Cell A10 with 45 degree diagonal orientation
(3) Enter any text into cell A10
(4) Hide cell A10
The button from Cell A8 disappears. You can still click it. You can check the properties programatically and it is still set to visible. But you can't see it.
This appears to happen with all of the rows above the hidden diagonally formatted row, but I have not tested extensively. Unfortunately, the workbook I am using has several hidden diagonally formatted lines and it cannot be made to function in 2007 for that reason. Possible solutions would be replacing the diagonal formatting with images, or using vba to change the format before hiding the row, and restore before unhiding. Not pretty.
Any suggestions?
Hi
I need to shade 1 half of a cell diagonally. So 1 diagonal half blank and the other diagonal half shaded.
Is this possible? I am using version 2003
thanks
dan
Is there a way to split a cell diagonally to have text on both sides of the diagonal, for example, the top left hand corner of a table. The bottom of the diagonal denotes the first column of the table and the top denotes the first row. Any ideas?
Within a single cell, is it possible to format a diagonal line with the area below the diagonal a different color than the area above the diagonal?
Hi all,
I have a spreadsheet onto which I have pasted several pictures as illustrations. I need to use the "lines" tool in order to draw arrows between text and images, but can't find the line drawing tool, nor the toolbar. F1 help just says to click on an existing line or drawing object in order to activate the drawing tab on the ribbon. Er...if I had one already I wouldn't need to make one myself..!
Am I being really dim? Where do I find the "line" tool?
TIA
Hi,
I have a line chart with 2 axis. I want to show how much a number of the vertical axis is worth on the horizontal axis, by drawing a line that goes from the first point, then passes thru the line, and then falls on the second point.
It was fairly simple to approximate this by drawing the lines manually with the drawing tool. However, this is inaccurate, slow, and resizing the chart messes it all.
So my question is, is there a tool that provides this feature somewhere in any versions of Excel or in Office?
Hi,
I believe the only way this could be achieved is using a drawing
object(s) i.e. triangle. You could colour the cell and then superimpose a
triangle over the cell (or use two triangles).
For a single cell this might be an option but for multiple cells it's not
(obviously) very practical.
"Andyfishing" wrote:
> I need to colour a cell that is split diagonally with 2 seperate colours?
> Excell 2003.
Occasionally I need to put big color text, something like: "PAID" or
"CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS.
How can I put it diagonally rather than only horizontally or vertically.
Thanks.
Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?
Hi there,
Is there any quick way to split a cell diagonally (i.e have item number/item reference in the same cell but splt diagonally by a line).
Thanks,
Stevie
Hi
Is there a way of adding a line to a graph (without using the drawing tool). The problem I have using the drawing tool (adding a line), is that if my scales changes drastically the line doesn't accommadate it.
I also don't wish to add or use alternative date. Just a simple line that moves according to my scales
Thanks in advance.
In Excel , how do I create a border line that is 45 degree or diagonal? I am trying to make a 3d table effect where the heading look like it is going out of the computer (not related to chart function).
I attached an example file of what I am trying to do. I wasn't able to figure how it was done in filename sample.xls. In the sample.xls, when I selected Format Cells > Border; I saw that the author did NOT make use of diagonal line but just vertical line but the border of the cell look diagonal in the spreadsheet.
Link to sample.xls
http://www.avsforum.com/avsvb/attac...7&d=1235418297
Thanks for your time & help!
WinXP with SP2
Office 2003
hi guys,
after excel formula to work out diagonal measure of rectangle. Eg, 100mm high by 160mm long = 188.88mm from one corner to other corner diagonally.
Any help is appreciated
Thanks Mal
Our IT dept just forced us (kicking and screaming btw) to convert to Office 2007. In the old version we used the excel drawing tool bar extensively, which was located at the bottom of the screen. In 2007 version, can I create a special Drawing tool bar that stays displayed in the same location?
Want to set up macro that does this...
if A2 and A6 are the same then take the cells below and divide, so A7/A2 and have it go in specified cell.
The add onto above can it be a range so A2:R2 and A6:R6 and having it do the division formula above.
So A2 = A6 so divide B2= B6 so divide but C2 C6 but instead D2 = C6.
I know how to put a diagonal line into a cell, how do I put a value in the one side of the diagonal and another value into the other side of the diagonal? Is this even possible? Thank you!
im not too experienced in drawing graphs in excel. here is what im trying to do.
yaxis:
100  0, at increments of 10
0.000 000.0
0.092 004.3 003 008
0.126 005.0
0.172 008.0
0.216 016.0
0.287 021.0
0.392 030.0 029 049
0.536 041.0
0.643 065.0
0.732 084.0 000 089
0.879 099.0 090 100
1.000 100.0 100
1.200 100.0
1.366 100.0
PROBLEM 1: i want to have a gridline at every xvalue (column 1), not at some scaled amount.
PROBLEM 2: i want to draw a line from 100 to 0, making a perfect diagonal line.
PROBLEM 3: i want to draw points, not lines, that correspond with the xaxis (column 3)
i dont have trouble graphing 1 line, but i dont know how to solve these more advanced problems.
I have been using 2007 for about a year now and I'm not really sure it's an improvement (yet). Some stuff is nice, but:
I really really really miss the drawing toolbar.
Now i'm in the middle of a project and I want to start doing some cool shadow boxes and lines and other stuff.
I'M STARTING WITH A BLANK SPREAD SHEET so PLEASE don't tell me to start by clicking on some drawing image to get to the tool bar! I got no images to click on! (Also, I find it really annoying that I must click on a drawing image to make the drawing image tools appear! How do you START making a drawing image!!?? HOW LAME!).
I really wish Bill Gates would have talked to me before he pulled the trigger on this one.
Is there any way to get the drawing tools to show on the ribbon?
Or is there a shortcut to it I can create??
HELP!
I'm trying to label cell A1 in an Excel spreadsheet so that the row name is
identified as well as the column name in this same cell A1, separated by a
diagonal. I can draw the diagonal, but how do you get the row name to appear
in the upper right of the cell and the column name to appear in the lower
left?

SgtBob
Hi, I am trying to program cell B4 to automatically divide itself into cells E4,F4. What I am trying to do is plug in a number into cell B4 and have it divide by 2 and put half into cell E4 and half into cell F4. Any ideas how to do this. Thanks
I want to place 2 numbers in the same cell w/ a diagonal line from the bottom left corner to the upper right corner. The line is intended to make the printed spreadsheet easier to read.
Is this possible? If so, how do I do it?
If not, what other options do I have besides the obvious merge of the row header? I feel the horizontal lines will not separate the large amount of $data on the sheet...
Looking forward to your responses. Thank you in advance.
Nicholas N.
I've placed a diagonal line in a blank cell, it appears in the print preview but won't print out, what am I doing wrong? How do I get it to print out?
Im not sure if the small function is what i want to use for figure out the data im looking for.
Im doing some calculations where im adding a series of numbers and getting the sum of those numbers in cells h6, h7 and h8. my goal is to find out the smallest numer of the three cells after dividing them by differant numbers
Example h6=3,214,512
h7=1,308,168
h8=691,104
m14= (answer im looking for)
Now to get what im looking for you would need to divide cell h6 by 10,000(Answer is 321.4512). divide h7 by 6,000(Answer is 218.028). also divide h8 by 2,000 (Answer is 345.552). So the smallest answer would be 218.028 (h7/20,000) which is what im trying to get put into cell M14. The numbers im using to divide changes and my results will not always be the h8 cell being the smallest, so i cant just divide that into the result. Im sure i can always do the division first and then find the smallest number by doing 2 differant functions, but im trying to eliminate the extra cells being used. My knowledge is small on the subject but i was trying to use something along the line of
Code:
=small((h6/1000)or(h7/6000)or(h8/2000),1)
This is not correct of course but this might help a little more to understand what im looking for.
Thanks for any help hopefully this isnt to confusing
Kyle