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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.