Hello, the problem is as follows, I try to cross out the cell diagonally and write what's above and below, then frame it and the effect and the problem look like this: when a cell wants to frame it looks like this, someone knows how to make the border not diagonally?

How would you draw a line (from the drawing set) across?

the inscriptions must be separated diagonally as in the first photo, when I make the border, it is done as in the second, I tried to draw the lines myself but you can see a makeshift, it's hard to hit the point and the thickness of the line, after that I have several dozen such cells and I would like it to be easy in the future I was going to add another

Excel is not a graphics program, so complex graphic effects overwhelm it a bit. I think the best effect is to add the texts as WordArt. Then the cell's border and strikethrough are independent, and the angle of the inscriptions can be precisely adjusted.

[Excel] - Diagonally Cropping, Framing Cell Text, and Borders: How to Achieve Desired Effects

Reply | New topic

#1 13415067 17 Mar 2014 20:27

DROITE DROITE

Level 10

» |

Post #1
13415067 17 Mar 2014 20:27

Hello, the problem is as follows, I try to cross out the cell diagonally and write what's above and below, then frame it and the effect and the problem look like this:

when a cell wants to frame it looks like this, someone knows how to make the border not diagonally?
ADVERTISEMENT
#2 13415130 17 Mar 2014 20:39

mrrudzin mrrudzin

Level 39

» | Helpful post? (+1)

Post #2
13415130 17 Mar 2014 20:39

How would you draw a line (from the drawing set) across?
ADVERTISEMENT
#3 13415253 17 Mar 2014 20:59

DROITE DROITE

Level 10

» | Topic author Helpful post? (0)

Post #3
13415253 17 Mar 2014 20:59

the inscriptions must be separated diagonally as in the first photo, when I make the border, it is done as in the second, I tried to draw the lines myself but you can see a makeshift, it's hard to hit the point and the thickness of the line, after that I have several dozen such cells and I would like it to be easy in the future I was going to add another
#4 13415811 17 Mar 2014 22:47

Maciej Gonet Maciej Gonet

VBA, Excel specialist

» | Helpful post? (+2)

Post #4
13415811 17 Mar 2014 22:47

Excel is not a graphics program, so complex graphic effects overwhelm it a bit. I think the best effect is to add the texts as WordArt. Then the cell's border and strikethrough are independent, and the angle of the inscriptions can be precisely adjusted.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

[Excel] - Diagonally Cropping, Framing Cell Text, and Borders: How to Achieve Desired Effects

Didn't find an answer? Ask Artificial Intelligence