How to Make Borders in Excel

How to Make Borders in Excel

Today’s tutorial is about how to make borders in Excel. And not only that! We’re gonna have a look at how to erase or remove the borders completely.

Let’s start!

Would you rather watch this tutorial? Click the play button below!

How to Make Borders in Excel

To draw borders in Excel, we need to select a relevant table area first.

How to Make Borders in Excel - relevant table area

Then we go to the Home tab, click on this little arrow next to the icon for ‘Borders’ and choose the bordering we want to apply.

How to Make Borders in Excel - home tab

We’ll select ‘Outside Borders’ and Excel immediately makes a border around the table.

How to Make Borders in Excel - outside borders
How to Make Borders in Excel - border around the table

To draw borders around each cell within the table, select the area again and now choose the option ‘All Borders’.

How to Make Borders in Excel - relevant table area
How to Make Borders in Excel - option all borders
How to Make Borders in Excel - borders around each cell

How to Adjust the Borders

If you’re looking for something different, you can use any style of borders you want. Simply, click here on ‘More Borders’ and under the tab Border you’ll find everything necessary to adjust the borders according to what you need.

How to Make Borders in Excel - option more borders
How to Make Borders in Excel - choose a style

So, let’s say we want to use a double line for the outside border. Look for the double line in the section ‘Style’, select this type of the line.

How to Make Borders in Excel - double line

And now we need to define where we want to use the double line, so we’ll click on ‘Outline’ right over here.

How to Make Borders in Excel - outline

We can check the preview of what the borders will look like once applied here.

How to Make Borders in Excel - preview

In a similar way, we can choose the colour of borders. For example, we want to use this dotted line style inside the table, so we’ll click on it, but we also want it to show in blue.

How to Make Borders in Excel - dotted line style inside the table

To do that, we need to go to the option ‘Color’ and select the shade of blue we want to use.

How to Make Borders in Excel - option color

The button ‘Inside’ located here at the top of the window will apply these settings to the inside borders.

How to Make Borders in Excel - The button ‘Inside’
How to Make Borders in Excel - inside lines

Have a look yourself and try out other possible options provided here, in this window!

As soon as everything’s been set, just click on OK to apply the changes and that’s it!

How to Make Borders in Excel - OK
How to Make Borders in Excel - result

But before we wrap it up for today, let’s have a look at one more thing.

If you decide to remove the borders, there’s more than one way to do that.

How to Remove the Borders Only Partly

The first one we’re gonna talk about helps you remove the border only partly. Go to the Border options, select ‘Erase Border’ and click on a border line you want to erase. And it’s gone! Once finished, press the Escape button to exit the ‘eraser’ mode.

How to Make Borders in Excel - option erase border
How to Make Borders in Excel - erase border line you want

How to Remove All Borders at Once

And here comes the second one, which is the most effective way to remove all borders at once. Select the area where you want to remove the borders. From the options, select ‘No Borders’.

How to Make Borders in Excel - relevant table area
How to Make Borders in Excel - option no border

Voila! All borders from the selected area have been removed!

How to Make Borders in Excel - all borders removed

Now you might also be curious how to get rid of the gridlines in a spreadsheet. If you want to know more, we’re happy to help! Learn how to hide gridlines in Excel in another of the tutorials by EasyClick Academy. The link’s in the list below.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.