How To Add Borders Automatically To Cells In Excel
ฝัง
- เผยแพร่เมื่อ 10 ก.ย. 2024
- How To Add Borders Automatically To Cells In Excel
All of us used borders in excel. Adding borders in excel is quite simple. Select the cell/cells you want to put borders on. Under the home tab within the font group, you’ll find borders. From there you can select all borders in excel. But this system has a flow. You can’t make it dynamic. For example, you want to enter data and the borders will be placed automatically. Though we can achieve that with table but that’s not the proper use of borders. Also, when you print your worksheet borders makes your data easily readable.
In this tutorial, I’ll create a dynamic formatting that will allow excel add border if cell contains text. Yes, whenever you write something, excel will apply borders automatically around your cells.
Now without further ado lets follow the instruction below to apply cell borders automatically in excel.
Step 1: Select the entire range you might or might not be using.
Step 2: Click on “Conditional Formatting”
Step 3: Click on “New Rule”
Step 4: Click on “Select Formula to Determine Which Cell to Format”
Step 5: Write this Formula
Step 6: Now Click on Format
Step 7: Go to Border and Select Outline.
Step 8: Click ok and ok again.
Done. Now whenever you write something conditional formatting will add borders automatically for you. This will create a dynamic border for you and you won’t need to insert border manually again.
#Excel #Border
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelco...
Excel VBA Programming Course: bit.ly/excelvba...
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutoria...
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@...
Quora: bit.ly/3bxB8JG
straight to the point, thnx
You're most welcome. Please subscribe and share.
Great help
Thanks
Very handy little trick.
Thanks. Please subscribe.
Very Good Sir....👌
So nice of you
Thanks 😊
You're most welcome! Please subscribe and share.
Sure ❤
I like this tut
You're most welcome. Please subscribe and be with us.
Thanks very helpful
I'm glad you like it.
Thank you!
You're welcome. Please subscribe and be with us.
Thank you so much!
You're most welcome. Please subscribe and be with us.
Thankyou.
You're welcome
Graet and helpful ✌️
Thanks Man
good sir
Thanks and welcome
Super
Thanks. Please subscribe and be with us.
good sir
Keep watching