EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Borders in Excel
 

Borders in Excel

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 21, 2023

Border in Excel

 

 

Borders in Excel

Borders are the boxes formed by lines in the cell in Excel. To distinguish specific values, outline summarized values, or separate data in ranges of cells; you can add a border around cells. By keeping borders, we can frame data and provide them with a defined limit.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Add Borders in Excel?

Adding borders in Excel is very easy and useful for outlining or separating specific data or highlighting some values in a worksheet. Normally, we can easily add all top, bottom, left, or right borders for selected cells in Excel. Option for Borders is available in the Home menu, under the font section with the Borders icon. We can also use shortcuts to apply borders in Excel.

You can download this Borders Excel Template here – Borders Excel Template

Let’s understand how to add Borders in Excel.

Example #1

For accessing Borders, go to Home and select the option shown in the screenshot below under the Font section.

Border Option

Once we click on the option of Borders shown above, we will have a list of all kinds of borders provided by Microsoft in its drop-down option, as shown below.

List of Borders

Here we have categorized Borders into 4 sections. This would be easy to understand because all sections are different.

The first is a basic section with only Bottom, Top, Left, and Right Borders. By this, we can create only one side border for one cell or multiple cells.

Border in Excel example 1-3

The second section is the full border section, which has No Border, All Borders, Outside Borders, and Thick Box Borders. By this, we can create a full border that can cover a cell and a table. Click No Border to remove the border from the selected cell or table.

No Borders

The third section combines the bottom borders, Bottom Double Border, Thick Bottom Border, Top and Bottom Border, Top, Thick Bottom Border, and Top Double Bottom Border.

Bottom Borders

These double borders are majorly used in underlining headlines or important texts.

The Fourth section has a customized border section, where we can draw or create a border as needed or change the existing border type. We can also change the border’s color and thickness as well in this section of Borders.

Draw Borders

Once we click on the More Borders Option at the bottom, we will see a new dialog box named Format Cells, a more advanced option for creating Borders. It is shown below.

Format Cells

Example #2

We have seen the basic function and use for all kinds of borders and how to create those in the previous example. Now we will see an example where we will choose and implement different Borders and see how those Borders in any table or data can be framed.

We have a data table with details of the Owner, Block, and Apartment No. Now we will frame the Borders and see what the data would look like.

As row 2 is the headline, we prefer a double bottom line selected from the third section.

And all cells will cover with a box of All Borders, which can select from the second section.

And if we select Thick Border from the second section, the whole table will be bound to a perfect box, and selected data will automatically get highlighted. Once we are done with all the mentioned border types, our table will be like this, as shown below.

Border Types

As we can see, the complete data table is getting highlighted and ready to be presented in any form.

Example #3

There is another way to frame borders in Excel. This is one of the shortcuts to accessing the functions available in Excel. For accessing borders, the shortcut selects the data we want to frame with borders and then simultaneously presses ALT + H + B to enable the border menu in Excel.

ALT + H + B

ALT + H will enable the Home menu, and B will enable the borders.

ALT + H

B enabling the Borders

Once we do that, we will get a list of all kinds of borders available in Excel. And this list itself will have the specific keys mentioned to set for any border, as shown and circled in the below screenshot.

List of Options

After selecting the data table, let’s use All Borders for this case by pressing ALT+H+B+A simultaneously. We can navigate to our required Border type by pressing the Key highlighted in the above screenshot, or we can use direction keys to scroll up and down to get the desired border frame. Once we do that, we will see the selected data is framed with all borders. And each cell will now have its own border in black lines, as shown.

Black Lines

Let’s frame one more border of another type with the same process. Select the data first and then press ALT+H+B+T keys simultaneously. We will see that data is framed with Thick Borders, as shown in the below screenshot.

Thick Outline

Pros of Print Borders in Excel

  • Creating the border around the desired data table makes data presentable to anyone.
  • A border frame in any data set is useful when printing or pasting the data into any other file. By this, we make the data look perfectly covered.

Things to Remember

  • Borders can be used with the shortcut Alt + H + B, which will directly take us to the Border option.
  • Giving a border in any data table is very important. We must provide the border after every work so the data set can be bound.
  • Always align properly so that once we frame the data with a border and use it in different sources, the column width will be automatically set.

Recommended Articles

This has been a guide to Borders in Excel. Here we discussed how to add Borders in Excel and use shortcuts for borders in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. LEFT Formula in Excel
  2. VBA Borders
  3. Format Cells in Excel
  4. Print Gridlines in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Borders Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Borders Excel Template

EDUCBA

डाउनलोड Borders Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW