How do you automatically build the row border of a table down in Excel?

First of all, open Excel, design the Contract Information table header, as shown below

Select $a: $F area, then select Start in the Ribbon, and click Conditional Formatting on the toolbar under Start to pop-up the menu window

From the menu that pops up, select the new rule option

In the new Formatting Rule window that pops up, select the use formula to determine which cells to format option, and edit the rule descriptions below the window to set the formula and format separately

In the formula bar, enter the formula "=or" ($A 1: $F 1<> ""), and then click the Format button below

In the Format Cells window that pops up, select borders, select lines, select Outline, click OK, and return to the previous window.

Then click the OK button to exit the Edit Formatting Rules window

Congratulations, you have finished setting the conditional formatting border.

Next, let's test that the table border is set correctly?

The table border is automatically increased when you enter content in a column in a table blank row A to column F. Down and so on, you can automatically generate a table border, whereas the table border will automatically disappear.

Classification:

• Excel Tutorials