Excel Powerful Tricks in 2022
In this video we learn how to add borders automatically to cells in Excel.
To add borders to cells automatically when you enter data, Please do with following steps.
1. Select the range of cells that you want the grid lines to appear on rows when you enter values. for example I will select the range of cells A1:F20.
2. From the home tab, Click conditional formatting and after that click on New Rule.
3. In the new formatting rule dialog box, Click use a formula to determine which cells to format under select a rule type section, And then enter this formula = A1 LTGT""
4. Then click format button in the new formatting rule dialog to go to the format cells dialog, click border tab and select outline border.
5. And then click OK OK to close the dialog.
6. Now when you type data in any cell of your selected range that you have applied conditional formatting, The grid lines will be added from Column A to column F of your selection automatically.
Watch video Excel Powerful Tricks in 2022 online without registration, duration hours minute second in high quality. This video was added by user Excel With Ravi 20 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 571 once and liked it 16 people.