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.
Смотрите видео Excel Powerful Tricks in 2022 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel With Ravi 20 Январь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 571 раз и оно понравилось 16 людям.