Merge cell diagonally

teotrip603

New Member
Joined
Oct 20, 2017
Messages
3
Hello there.

I would like to have a cell shappered diagonally but its side of diagonally to have its own adress, like at the top left a function and at the bottom right different function.

Like that:


J
K
34

=SUM()
=SUM()
35



36




<tbody>
</tbody>



J+K
L
34

=SUM() =SUM()

35



36




<tbody>
</tbody>

Ok maybe like that, but imagine where is a fuction there is and a diagonally line.
:p

Thank You
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
I guess you have to ask this from Microsoft because; this cannot be done with the most current version of Excel's abilities, as of today.
 
Upvote 0
Thank you for the reply.

Yes, I have it already in my mind, I guess its tie to ask developers of Excel.

But tell me if someone has already needed than option?
 
Upvote 0
Actually,i have never needed that kind of an option.

I guess, you will have to design your table in another way to achieve your goal.
 
Upvote 0
The point at the end is to have one printed column with two types of data shapered by a diagonally line. Do you have any idea how can be that even with print settings to be one column over the other?

Thank you.
 
Upvote 0

Forum statistics

Threads
1,216,756
Messages
6,132,533
Members
449,733
Latest member
Nameless_

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top