HOW TO ADD BORDER IN EXCEL?

Table of Contents

INTRODUCTION

In this article, we’ll learn about how to add border in excel using various ways to apply or remove borders, difference between merging and borders and more.

Borders are the dark lines which divide the various areas within a table or any defined figure.

We deal with a lot of data in Excel and standard cells are having light colored lines which divide our workspace into cells. What if we want to club two or more columns or rows together without merging. [ Merging merges the cells but borders doesn’t merge the cells ]

We can do so using the borders.

WHAT IS A BORDER IN EXCEL?

Simply stating, border is an outer edge or the outer limit of any area.

In our context, border is the outer limits or the boundaries of various smaller or whole area in the given sheet.

These are the dark lines which will be printed darker in comparison with the criss cross cell lines.

HOW TO ADD BORDER IN EXCEL?

Follow the steps to apply a border to a table in Excel

  1. Select the complete data where you want to apply the border.
  2. Go to TOOLBAR and click BORDERS as shown in the picture below.

how to add border in excel
CHOOSE BORDER
  1. Choose the border of your choice and click it.
  2. The border will be applied.
borders applied in the example table
RESULT

In this way we can add border in excel to any table or data in Excel.

HOW TO REMOVE BORDER IN EXCEL?

It is very easy to remove the borders.

Follow the steps to remove the borders in Excel.

  1. Select all the data from where you want to remove the borders.
  2. Go to TOOLBAR>BORDERS>CLEAR BORDERS as shown in the picture below.

option to remove  borders in excel
REMOVE BORDERS
  1. The borders will be removed.



FAQs

HOW TO ADD DOUBLE LINE BORDER TO THE DATA IN EXCEL?

Double line border is the border where the Tabular lines are made up with two parrallel lines.

You just have to follow the standard procedure of border-applying as discussed above.

  1. Go to the Border Selection menu and choose LINE STYLE.
  2. Choose DOUBLE LINE from the list.
  3. Now, choose ALL BORDERS.
  4. The double line border will be applied.

HOW TO ADD THICK BOX BORDER IN EXCEL?

Thick border is made up of a thick solid line which shows the boundary of the border.

You just have to follow the standard procedure of border-applying as discussed above.

  1. Select the Border format as THICK OUTSIDE BORDERS.
  2. The box border will be applied.
  3. It is the box border so only the outer line will have a thick line.

HOW TO ADD TOP AND BOTTOM BORDER IN EXCEL?

Top and Bottom border is represented by a line at the top of the table or data and a line at the bottom of the table or data.

You just have to follow the standard procedure of border-applying as discussed above.

  1. Select the Border format as shown in the picture below.
  2. Go to BORDER STYLE and choose TOP AND BOTTOM BORDER.
  3. The top and bottom border will be applied.

HOW TO ADD BOTTOM DOUBLE BORDER IN EXCEL?

Bottom double border is the type of border where a double line is put at the bottom of the data or table.

You just have to follow the standard procedure of border-applying as discussed above.

  1. Select the Border format as shown in the picture below.
  2. Go to BORDER STYLE and choose BOTTOM DOUBLE BORDER.
  3. The bottom double line border will be applied.



WHAT IS THE SHORTCUT TO APPLY BORDER IN EXCEL?

We can use a simple shortcut to open the menu of the borders and select the borders by Up or Down key.

Follow the steps to apply border using shortcut in excel.

  1. Select the cells where you want to apply the borders.
  2. Press ALT+H+B.
  3. The border menu will open showing the key letter for choosing any specific border.
  4. Choose the relevant border by pressing the key and the border will be applied. For example, A for all borders, O for bottom border, L for left border and more.