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.
:nya:

Thank You
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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,223,788
Messages
6,174,570
Members
452,573
Latest member
Cpiet

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