Lesson 3: How to Create Border in Excel

Today I am going to talk about border that how we can create in excel.

How to create border in excel program.

Border

When we start working in excel sheet we create headings in separate columns with entries, for single entry it's fine but if there is a lot of entries we create border.

These borders help us to easily understand and looks as a separate section of each column along with entries and also the work can be done in good manner.

Border can be created in single cell or with cell range, as we see in excel home menu bar there is a border tab and under that there are so many options to create borders for bottom, top, left, right or full border to cover all sides.

There is also other way which is so easy to add borders, just select single cell or range of cells where to add border and then. (1) Right Click Mouse, (2) Click Format Cells (Pop up Screen will Appear), (3) Click Border Tab. Now you can easily add borders and also you can change its line style and color.

 Creating border by clicking on border tab in home menu in excel program.

Creating border from format cells option in excel program.