How to Draw a Diagonal Line Through a Cell in Excel – Excel Tips and Tricks

How to Draw a Diagonal Line Through a Cell in Excel – Excel Tips and Tricks

HomeOther ContentHow to Draw a Diagonal Line Through a Cell in Excel – Excel Tips and Tricks
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Rabi Gurung2022-11-26 16:00:26 Thumbnail
3,088 Views
Learn how to draw a diagonal line through a cell in Excel. This is expecially good to show as a divider between row and column headers.

Here are the steps to draw the diagonal line
1) Select table corner cell.
2) Ctrl + 1
3) Border tab
4) Click on diagonal line.
5) OK

Here are the steps to add text to the header cell.
1) Select table corner cell.
2) Add a few spaces and enter row header text; /”Month/”.
3) Alt + Enter to add new line
4) Enter column header text; /”Name/”
5) Press Enter when done.

Here are the steps to change font size of the header text
1) Double click /”Month/”.
2) Change font size to 8.
3) Double click /”Name/”.
4) Change font size to 8.

I do not own the /”Drawn Number Circle Png/”. You can find that from the link below.
Drawn Number Circle Png – Red Marker Circle Png @clipartmax.com
https://www.clipartmax.com/middle/m2i8G6m2b1d3H7d3_drawn-number-circle-png-red-marker-circle-png/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.