How to Add Borders in Excel: Step-by-Step Guide (2024)

Are you tired of staring at bland, uninspiring Excel spreadsheets?

Adding borders is a simple yet effective way to make your data stand out and look more professional.

Whether you’re creating a report or a household budget, adding borders can take it to the next level 💪

In this guide, we’ll show you how to add borders to cells and customize your borders to fit your specific needs.

With a few clicks, you will be able to transform your dull Excel sheet into a masterpiece 🧐

You can also download our sample workbook here to practice adding borders in Excel.

How to add borders

Adding borders to a spreadsheet is extremely easy, and you can add them in less than two seconds.

Want to know how? Read on 🤓

We have some sample data below.

Sample data for border in Excel

To add borders to this data set,

  1. Select the data range.
Select custom border range to draw border grid
  1. Go to Home Tab > Border options under the Font group.
Go to Home Tab > Border Options
  1. Click the dropdown and select the All Borders option.
Select All Border option from the border tab
  1. The borders will appear around all cells as:
Cell border appear around cells

Pro Tip!

If you don’t want to add borders to all sides of a cell, you can choose to add borders to specific places. For instance, you can add a border to the left side of a cell using left border and so on.

Outline cells with borders

You can also choose to outline your cells with borders, and the process is simple.

To do that:

  1. Select the cell or range to be outlined.
  2. Go to Home Tab > Border Options.
Select Border options from Home Tab
  1. Select Outside Borders from the options or Thick Outside Borders.
Select Outside borders to draw cell borders
  1. Outside borders will immediately be applied to your selected range as:
Custom Cell border style appears

Pretty quick, no? 😏

Add thick borders

You can also change the thickness of cell borders in a couple of clicks.

To do that,

  1. Select the range of cells.
  2. Go to Home Tab > Border options.
Go to Home Tab > Border options to draw borders
  1. Click the dropdown menu and select Line Style at the bottom.
  2. Select the last border style.
Select line styles for custom border style from the borders drop down menu
  1. A pencil will appear on your worksheet. Use it to draw thick borders as:
Thick borders appear around the range

Isn’t this a fun thing to do? Try it yourself! 😃

Change borders

You can change anything in a border, from color to line style. Let’s now see how to change borders in the Excel sheet.

The following sample data contains all borders.

Sample data for more borders changes

We want to add thick outside borders and change their color.

To do that,

  1. Select the range of cells containing borders.
  2. Go to Home Tab > Border Options.
  3. Select Thick Outside Borders from the list.
Select thick outside borders for a new cell style
  1. Click Border options again and go to Line Color.
Selecting line color from border options
  1. Select the line color for your borders – we selected red.
  2. A pencil will appear on the screen. Select the cells whose color you want to change.

The color appears on the borders as:

Red colored borders appear on screen

How cool is this? You can choose any border style and color you like 🎨

Practice applying borders in real-time by using this guide’s sample workbook above.

Remove borders

Removing borders is as simple as adding them, and there are two ways to remove borders. We will explore both of these methods below.

Say, we have the following data to which we have applied borders.

Sample data for predefined cell borders

We want to remove all the borders in the worksheet.

To do that,

  1. Select the cell or range that contains borders.
  2. Go to Home Tab > Border options.
  3. Select No Border from the options.
Selecting no border option from the drop down menu
  1. You can also remove borders using the Erase borders option at the bottom ✏️
Selecting erase border to remove cell borders in Excel
  1. An eraser icon will appear on the screen. Select the cell borders you want to erase.

All the borders will be removed as:

final result after removing cell border in spreadsheet

And it’s done! Pretty easy, no? 🤩

That’s it – Now what?

In this article, we saw how to add borders in Excel. We also saw how to outline cells with borders, change borders and even remove them.

Borders can instantly add a look of sophistication to your Excel spreadsheet. With the easy-to-follow steps outlined in this guide, you can quickly add borders to your cells.

So why not take a few minutes to spruce up your spreadsheet and give it a polished look it deserves? 🥇

Similar to adding borders, Excel has a variety of other useful tools and features. The most important of which are Excel functions. Some of these include IF, SUMIF, VLOOKUP, etc.

You can learn them for free in my 30-minute free email course that teaches just this and more. So sign up now!

Other relevant resources

Did you learn something new from this guide today? If yes, then you’d love to know more.

Read similar topics: Conditional FormattingNumber FormattingClear Formatting, and more.