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