Create Angled or Slanted Text and Borders
HTML-код
- Опубликовано: 21 авг 2024
- How to create slanted, angled or sideways text in Excel. The example show a 45 degree orientation for headings. It almost looks like the cell is being split diagonally, but it's just a rotation of the text. There are also other ways to rotate the text direction such as making the text align vertically. The video finishes with formatting such as adding borders that are also angled.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Really helpful. My boss asked how to do this and I said, "I don't think you can, but let me check." This was such a great tutorial. Thanks!
I really like how you cover stuff. Just the right amount of explanation and you're really chill and easy to listen to
Thanks for the kind words!
Thank-you so much!! You just taught me exactly what I wanted to learn!!! You're a gem!
Thanks for the kind words!
I had such an embarrassing situation because i didn't know how to do this angled borders, but your video here saved me at the last minute.
### THANKS ###
You're welcome@!
Finally, I found how to angle the boarders...Thank you very much, this has been of great help !
Thank you so very much. What a wonderful simple, to the point video. I took advance spreadsheets in college and after many years not working with excel, I have forgotten all the tricks. I hope you have more videos out there... I will be searching for them :)
This is a great tutorial! I have watched it a couple of times. Thank you!
Thank you so much!!! I followed your tutorial and my Excel table worked so nicely. Your explanation was concise and clear!!!!
Glad you liked it; thanks for the comment!
Thanks so much! I learned a few things, especially left aligning the slanted headings. I was doing it thru Format Cells but it would not left align until I used the alignment icon like you demonstrated. So simple! Thanks a lot! Much appreciated!
Fantastic tutorial, I have used excel for years and I still learned a lot. Thank you!
You're very welcome!
i needed this, and your video is very helpfull! Thank You!!
Glad it was helpful!
Amazing tutorial. Every time I thought "yes, okay, but now what about ", it was your next step. Even though this video is 7 years old, it's still absolutely useful in the latest Excels. Thanks!
Hi SadBunny, thanks for the kind words!
Awesome tutorial
Glad you liked it
You are so different from me when it comes to Copying & Pasting. I Highlight The Text then I Press Control C at the same Time, then I move it then I go Control V for Paste.
Great video Thank you!
Glad you liked it!
Perfect! Thank you
You're welcome!
Man, thanks for this. It's odd that I've searched quite a bit on google, yet wasn't able to find how to bring the columns to go sideways.
Thanks for the clear and concise instructions! Well done!
Thanks dude! Tons of help! Great video!
This was a very helpful video. It answered my questions and helped me to create the form I needed. Thanks!
Thank you it's help for my project
Glad it helped!
Thank you it was explained clearly. Appreciate your sharing.
Thank you so much for this tutorial! It was everything I needed :) You explained it all perfectly!
Glad you liked it. Thanks for the comment!
Very easy to learn, great instruction!
Yes, this helped! I knew I was making it much more difficult than it had to be.
This help alot thanks, an older video and its still useful today 😊
Glad it helped!
Thank you
Watching this in 2020, thanks dude
You bet
Thank you so much this helped me
Glad it helped!
Gr8 tutorial! Thanks!
You're welcome!
IT REALLY HELPED ME THANKS FOR POSTING
Well explained. Thank you
Hi mympv, thanks for the comment!
Great Video, I just used everything in this video.
Thank you , good sir
You are welcome
great tutorial.
actually i have learn excel which i needed form your tutorial.
i appreciate to learn more from you.
Cool trick ! Thanks Doug !!
Well done. Exactly what I was looking for.
Thank you, it really helps a lot!!
Glad it helped!
Very helpful
Thanks Kelley Pope, glad it helped!
Now that is a tutorial on how to do it and make it look good!
Thanks for the comment!
Awesome Video. Thanks!
Thank you, very much helpful!
You're welcome!
Very helpful instructions , Thank you!
Hi Sylvia Algiene, thanks for the comment!
Excellent tutorial, thank you for your time.
Thank you so much! Great tutorial, definitely help me excel at work!
Thank you! This help me all together.
Glad it helped!
You've got a new subscriber! Such a great tutorial. thank you
Hi Melanie Powers...you're welcome, glad you liked!
Very Helpful, thank you
Thanks zappulmo, glad it helped!
Thanks Doug... It really helped
Thanks Raghuram Manda Venkata, glad it helped!
This was helpful! Does anyone know how to have this feature available in the web version of excel in onedrive?
great tutorial friend
Thank you so much! This video was exactly what I was looking for!!
Thanks Dawnrobin5, glad it helped!
Thank you, this is exactly what I wanted.
Very helpful.Thanks
Glad it helped! Thanks for commenting!
Thank you! So helpful!
You're welcome!
thank you
You’re welcome!!
How to copy and paste in new work sheet in same direction.
Thank's so much this is really beneficial :)
I made the slanted lines, but I'm trying to keep the slanted lines without any text. So basically delete the "Heading1", but still keep the formatting so I can go in later and write what i want with a pencil. When I deleted the "Heading1" etc. it got rid of the slanted lines. Do you know how I can solve this?
Nice Video helped alot to this day.
Glad it helped!
Very nice, I wish I could angle stuff in the userform like that :(
Thanks for the tutorial... but why won't it let me have slanted gridlines for merged cells? Is there a different process for that?
Awesome thank you very much!
You're very welcome!
Thanks for the help! :)
Thanks Ed Lazor, glad it helped!
Thank you now i dont have to worry about our hand on in our cumputer subject in school
Thanks!!!
I also tired to angle text when I merge rows and it doesn't seem to work - Excel 2010
Thank you!!
Hi Mette Riggs, thanks for the comment!
Doug, this is great. I did this exaclty what you did in Excel it works well. But when I insert the table in PPT, it does not work.. Do you know how to do it?
when pasted into PPT, there's a small icon near the image, click it and select either embed or as picture
Can this be done to the rows as well? I can't seem to get it to work for rows.
Excellent , I like it......thnx
Hi Shaukat Samad, glad you liked it, thanks for commenting!
thanks for the tip
You're very welcome!
Mine didn't work. I followed the instructions, but the borders remained vertical. Is it because they're merged cells or I can't apply special fills to them?
Yes, I tried different sequences, but I don't think it matters, only the text follows the new alignment. My Excel is 2007, maybe in a newer version it works. But it's ok, I unmerged them and it actually looks cooler with a black line going through the text, it's like an old alarm clock.
Awesome, that's for you informative video.
Hi Bryan Ferguson...you're welcome, glad you liked!
Hi thanks for a video. I had an idea how to do it, but auto-alignment is not working without borders, strange.
Hi Martin 'Betlista' Šuška, thanks for the comment!
HELP! What if i want 2 rows to be slanted? both row slanting will not be alligned.
try to toggle or reset it back to normal, select both rows and try the orientation command from the Ribbon again
Problem solved😊thanks for this 😊
Thanks Zevonni Dolotallas, glad it helped!
Doug H yeah very much
This worked fine when I did exactly what the video did. But what I wanted to do was have longer headings columns 1-10 and then shorter columns 11-13, so I merged two rows columns 1-10 and then tried to change the alignment to 45 degrees. But now the boarder is straight up horizontal/vertical. I can't change the borders to slanted orientation now because I have merged 2 cells. Most annoying tbh.
Hi Ajay Empee, thanks for the comment!
Great Video! You have a new subsciber here too
Hi darlene daniels, glad you liked it, thanks for commenting!
Any idea how to do this for rows? When I try the rows don't overlap properly.
Not sure of a solution for rows :-(
What about in phone, bc theres no orientation option in phone
Sorry, don’t understand the comment/ question...
Thanks! Upload to office.com templates ;)
How if we want to make the roof: House of Quality manually in excell?
Sorry, don’t understand the comment/ question...
how to un-bordered rotated text in a cell with outline border?
under the Home tab, Font group there is a border command icon that will let you adjust.
Is there a way to do this for Microsoft Wor?
Not that i know of in Word. If you want to have this style of table in Word, create it in Excel, copy and paste as a picture into Word.
@@DougHExcel thank you!