• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » 2 ways to create border in excel

2 ways to create border in excel

February 23, 2021 by Alice Leave a Comment

When you enter data in cells in Excel, you will see line around those cells. They are designed to make it easier for users to work. If you do not have a border, you will not see the lines when print your page, you just only see data you have entered. This brings unprofessional for your work.
You want to create a properly designed data or you do not know how your data have a Table style like in Word. I will show you 2 ways to create border in excel. It is very simple but very powerful ways.

Post contents

  • 1. Create border in excel by border tool.
  • 2. Draw borders in Excel with optional strokes.
  • 3. Delete a border in Excel.

1. Create border in excel by border tool.

After importing data content in Excel, if you want to quickly outline the data areas, you can do following steps:
Step 1: Scan / highlight the entire data area that you want to border.
Note: Because I want to frame all data here, I scan and select all data. If you want to frame rows, columns, cells, you can select correspondingly.

input data in excel 210223

Step 2: Then you go to the Home Tab, at this point you will notice the Font tool group => click on the Border tool.
There are many options here, if you want to draw the entire border to the data, choose All Borders.

excel-home tab-border tool-all border

Step 3: Check the results, now you can observe that the data has a border around it.

Create border in excel by border tool

However, if you do this way, the strokes that surround the content will be single, and you have only one option.
In case you want to draw the table of data contents in Excel with different strokes like double stroke, bold line or dashed line…. How will you do it? Let’s move to 2nd way.

2. Draw borders in Excel with optional strokes.

For example, I want to outline borders for an Excel data table with the following requirements: The outer strokes are double strokes, while the inner strokes are dashed strokes, I will:
Step 1: Also scan / highlight the data area that I want to draw borders => Then go to the Home Tab => next go to the Borders tool and select the More Borders …

excel-home tab-border tool-more border

Step 2: At this time, you will see a dialog box Format Cell => choose to go to Tab Border. In Section Style => you choose to double stroke.
If you want to choose the color for the stroke, choose Color => then tick the Outline to draw the outline borders.

excel border options

Step 3: Next, you select the dash line in section Style => then tick Inside to draw a border inside the contents of the data sheet.
After you have seen that the outer contours are double strokes, and inside are dash lines => click OK to confirm.

excel-format cell

Result: You can observe that the outer outlines appear as double strokes, while the inside is dashed.

Draw borders in Excel with optional strokes

If you want to draw the data sheet with other strokes, the way to do it is the same as I instructed above!

3. Delete a border in Excel.

If you do not want to create a border, you can delete it with the following way:
+ Option 1: Scan / highlight on the data sheet => then go to Tab Home => go to Borders and select No Border.

delete border in excel

+ Option 2: Scan / highlight the data sheet => then right-click and select Format Cell. Or press CTRL + SHIFT + F to open the Format Cell.

excel-format cell-210223

Next, go to Tab Border => and select None. Or if you just want to remove a few lines, click on the appropriate option.

format cell-none border

Return to the Excel screen, you will find that the entire border on the data sheet has disappeared.

excel remove border

CONCLUSION
So, I have show you 2 ways of how to make a border in Excel. This is a very simple and basic knowledge, but it is extremely important in the process of using Excel. Choose the most suitable way for you. Hopefully this article will be useful to you, wish you success and do not forget to visit the Blog everyday to learn more interesting things!

Related posts:

Remove border lines in word by using Borders and Shading 33 ways to remove border lines in word convert comma to dot Changing Number Separators 52 ways to convert comma to dot in excel Writing in cell with diagonal line 34 ways to insert diagonal line in Word table change cell background color automatically in excelchange cell background color in excel by equal formulas

Filed Under: excel tips Tagged With: excel beginner, excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in