• Dp

How To Correctly Apply Borders To Tables In MS Excel

In this video tutorial, let us learn how to apply borders to a table in MS Excel. 

I Prefer this method which makes our data speak out because sometimes the table borders lead to distraction. 

First, let me show you a bad way of applying borders to a table, which is exactly distracting from the data (like shown below).

So, now let us see how to apply borders in a correct way as part of formatting for it to be more presentable.

Follow the steps:

Step 1: Select the entire data range including the headers and right click and select the option "Format Cells".

Step 2: In the Format Cells dialog box, go to "Border" tab.

Step 3: under color field, select the Grey color from the drop don menu.

Step 4: Select a normal line from the style and apply this style to the horizontal borders of the table and dashed line style to the vertical borders like shown below.