HOW TO ADD OR REMOVE BORDER IN EXCEL?

Table of Contents

INTRODUCTION

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.

In this article, we’ll learn the various ways to apply or remove borders, difference between merging and borders and more.

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 APPLY BORDER TO A TABLE IN EXCEL?

Follow the steps to apply a border in Excel

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

CHOOSE BORDER
  1. Choose the border of your choice and click it.
  2. The border will be applied.
RESULT

In this way we can apply borders 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.

REMOVE BORDERS
  1. The borders will be removed.



FAQs

HOW TO APPLY 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 APPLY 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 APPLY 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 APPLY 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.