top of page
  • Writer's pictureDp

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.

Step 5: Now again select the color as "Automatic", changing it from grey color.

Step 6: And apply the 6th Line Style____ as outline border to the table.

Step 7: Select the Header row and apply the outline border from the menu bar directly.

Step 8: Apply the formatting like blue color to fill and white font color as shown here:

So, finally after applying the formatting styles, our table would be like this as shown which will be much more presentable.

Watch this video tutorial for better understanding:

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you. You can write us at


Recent Posts

See All


bottom of page