HomeApplicationOffice information

How to automatically create valuable cell borders in Excel

When setting up a table of data in Excel, if we just need to format the table at a basic level, then adding borders to the table also ensures the creation of an Excel table. And when processing the table there will be cases where we fill in the value after calculating. Instead of having to manually add table borders, you can automatically create borders for valuable cells in Excel. To create automatic borders for valuable cells in Excel, users will use the conditional formatting feature and guided by the Network Administrator in the following article.

  1. How to format borders and background colors for Excel tables

Instructions to create automatic borders for cells containing Excel values

Step 1:

The user highlights the area that needs to be facilitated when entering a value and then press Conditional Formatting> New Rule .

How to automatically create valuable cell borders in Excel Picture 1

Step 2:

Display the New Formatting Rule dialog box, click on Use a formula to determine which cells to format . Then again the New Formatting Rule dialog box, enter the formula = B13 <> '' and click Format to continue. B13 is the first cell in the selected area.

How to automatically create valuable cell borders in Excel Picture 2

Step 3:

In the Format Cells dialog box, we click on the Border tab and then click on select Outline to create the border for the cell. Click OK to save the new format. If you like, you can choose the border style and color if desired.

How to automatically create valuable cell borders in Excel Picture 3

Finally click OK to apply conditional formatting to the data table.

How to automatically create valuable cell borders in Excel Picture 4

Now that we do the calculation, enter the values ​​in the cells at the original selected area. The result of the cell values ​​is automatically added borders with the type of border format you set.

How to automatically create valuable cell borders in Excel Picture 5

See more:

  1. How to use conditional formatting in Microsoft Excel 2016
  2. How to calculate and color blank cells in Excel
  3. 4 basic steps for alternating coloring of lines in Microsoft Excel
  4. How to automatically highlight rows and columns in Excel

I wish you successful implementation!

3.3 ★ | 4 Vote
create Excel table bordersConditional Formatting excel

You should read it

May be interested

  • Diagonal lines in a cell in ExcelDiagonal lines in a cell in Excel
    instructions on how to diagonal lines in a cell (excel) help you present the table quickly and beautifully. to create diagonal lines, just right-click the cell you want to create a diagonal - select format cells: the dialog box appears, select the border tab - click the icon.
  • The most detailed way to format borders for Excel tablesThe most detailed way to format borders for Excel tables
    inserting tables in excel is extremely familiar to anyone who works with office tools. we can arbitrarily design the interface and make the table more prominent in the content by formatting the border for the excel table. so do you know how to format table borders on excel application?
  • Complete tutorial of Excel 2016 (Part 5): Basics of cells and rangesComplete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
    whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the basics of cells and cell contents to calculate, analyze, and organize data in excel.
  • How to create a blur border in a Photoshop imageHow to create a blur border in a Photoshop image
    creating blurred borders in photoshop images is like creating spotlight images, focusing on one pixel and blurring the surrounding area.
  • How to delete table borders in WordHow to delete table borders in Word
    how to delete table borders in word, which is a question that many people will probably wonder if not formed in using word software. first you need to black out the table cell to remove borders. the highlighted method is to click and drag the mouse to the cells you need to select.
  • How to wrap text in an Excel cell - Wrap text in an Excel cellHow to wrap text in an Excel cell - Wrap text in an Excel cell
    how to create a newline in an excel cell - wrap text in an excel cell
  • How to name a cell or Excel data areaHow to name a cell or Excel data area
    on excel, users can give a name to each individual cell or cell to easily remember the address of the corresponding cell when referring to the data area.
  • How to create borders in PowerPointHow to create borders in PowerPoint
    if you want to add a border in powerpoint, we have many different ways to do it as well as beautiful border styles in powerpoint for you to choose from.
  • How to create notes for documents in ExcelHow to create notes for documents in Excel
    instructions on how to create notes for documents in excel. you can customize the comment to a formula or to a data cell in a spreadsheet by doing the following steps: step 1: select the cell to insert a comment - go to review - new comment tab.
  • Format borders and background colors for tables in ExcelFormat borders and background colors for tables in Excel
    instructions on how to format borders and background colors for tables in excel. step 1: select the table you want to create a border for - design - quick styles - select the table style: light is the light color format, medium is the medium format.

Office information