• 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".