How to Add Border in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Add Border in Excel



In this tutorial, you will learn how to add border in excel. The knowledge of how to create a border in excel is needed to get preferred cells, rows, or columns borders. By knowing how to do it, you will be more able to make the data interface grouping as you need it.


Why do We Need to Learn How to Insert Border in Excel?


In doing spreadsheet data processing, sometimes we need to add some kind of cell boundary line. This boundary is not the default one in this software (the gray-colored ones which we usually see). The boundary that we want to make is usually thicker and used as a clear separator between one data part and another. This is sometimes needed especially if we have much data and want to divide it. Or probably when we want to mark particular parts of sheets’ contents in our spreadsheet.

As an example of this need at work, imagine we input various data related to the sales performance of a company branch. Maybe the data consists of many things such as salespeople data, product offerings, promotion programs, and others. Each is different and sometimes we want to put all in one sheet to make the processing easier. To separate them, we will use borderline. But, before using it, of course, we must understand first how to use it.

There is a feature available in this spreadsheet software to do it easily. To access this feature, you can use some methods. It is better to know at least one of the methods of how to add border in excel. By understanding it, then it will be much easier to do what you want to do on your data interface.


What is How to Add Border in Excel?


How to add border in excel is a function that will give give a clear separation between cells. This separator is useful to divide data in a sheet or to beautify the data interface according to your preference.


How to Put Borders in Excel?


The following will explain how to add border in excel. Three methods of how to add border in excel will be explained in detail so you can understand the usage. The three of them should be able to produce the same result in your cell ranges.


Method 1 - Borders Menu

  1. Highlight the cell range where you want to put in the borderlines

    How to Add Border in Excel - Screenshot of Step 1-1

  2. Click Borders menu dropdown in the Home tab

    How to Add Border in Excel - Screenshot of Step 1-2

  3. Choose the type of border you need or click More Borders…

    How to Add Border in Excel - Screenshot of Step 1-3

  4. If you choose More Borders…, then choose the line style and line colors of your borderline on the left side according to your preference

    How to Add Border in Excel - Screenshot of Step 1-4

  5. Add your choice as the cell borderlines on the right side

    How to Add Border in Excel - Screenshot of Step 1-5

  6. Repeat step 4 and 5 until the cell boundary form is as you prefer
  7. Click OK

    How to Add Border in Excel - Screenshot of Step 1-7

  8. Done!

    How to Add Border in Excel - Screenshot of Step 1-8




Method 2 - Draw Border

  1. Click Borders menu dropdown in the Home tab

    How to Add Border in Excel - Screenshot of Step 2-1

  2. Pick the line colors that you prefer

    How to Add Border in Excel - Screenshot of Step 2-2

  3. Repeat step 1 and pick the line style that you prefer

    How to Add Border in Excel - Screenshot of Step 2-3

  4. Repeat step 1. Choose Draw Border if you want to only draw the outer borderline of your cell range. Or choose Draw Border Grid if you want to draw the outer and inside borderlines of your cell range

    How to Add Border in Excel - Screenshot of Step 2-4

  5. Your pointer will change form. Now, click and drag your pointer on the cell range where you want the borderlines are
  6. Repeat step 2 to 5 until the cell boundary form is as you prefer
  7. Done! Don’t forget to press Escape to return your pointer form as it was before

    How to Add Border in Excel - Screenshot of Step 2-7




Method 3 - Format Cells

  1. Highlight the cell range where you want to put in the borderlines

    How to Add Border in Excel - Screenshot of Step 3-1

  2. Right-click on the highlighted cell range and choose Format Cells…

    How to Add Border in Excel - Screenshot of Step 3-2

  3. Click the Border tab on the dialog box that shows up

    How to Add Border in Excel - Screenshot of Step 3-3

  4. Choose the line style and line colors of your borderline on the left side according to your preference

    How to Add Border in Excel - Screenshot of Step 3-4

  5. Add your choice as the cell borderlines on the right side

    How to Add Border in Excel - Screenshot of Step 3-5

  6. Repeat step 4 and 5 until the cell boundary form is as you prefer
  7. Click OK

    How to Add Border in Excel - Screenshot of Step 3-7

  8. Done!

    How to Add Border in Excel - Screenshot of Step 3-8



Exercise


After you understand how to add border in excel through different methods, now is the time to test your understanding. The test is done by doing the exercise below!

Download the exercise file.

Link of the exercise file:
Download here

Look at the data form in sheet 1 and sheet 2. Try to make the data form in sheet 1 to become like in sheet 2 (with exactly the same borderlines). What is the result? Can you do it?


Additional Note


To make the boundary lines clearer, you can also hide the default vertical and horizontal lines on this software if needed. If you don’t know how to do it and want to learn, then check out the tutorial which discusses this!



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert