Cells Borders

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Cells Borders

Introduction

The alignment we have used so far is applied to the contents of a cell or of a group of selected cells. As we have mentioned already, a cell appears and behaves like a rectangular box. As such, it has borders and a background. Microsoft Excel provides a default appearance for a cell with regards to its background. For example, it surrounds the cell with a gray border and a white background. You can keep these defaults or you can change them as you see fit.

To control the borders of a cell or a group of cells, on the Ribbon, click Home. In the Font section, click the arrow of the Borders button and select one of the options:

Border

Practical Learning: Adding Borders to Cells

  1. The Grier Summer Camp2.xlsx workbook should still be opened with the Sheet1 selected
    Select cells B2:J2
  2. On the Ribbon, click Home if necessary.
    In the Font section, click the arrow of the Borders button
  3. Click the Top And Double Bottom Border option
  4. Select cells F6 and G6
  5. On the Ribbon, click the arrow of the Borders button and click the Bottom Border option 
  6. Randomly select cells F5:G6 and I29
  7. On the Ribbon, click the arrow of the Borders button and click the Bottom Border option  
  8. Select cells I6:J6
  9. On the Ribbon, click the arrow of the Borders button and click the Top And Bottom Border option
  10. Select cells A9:A27
  11. On the Ribbon, click the arrow of the Borders button and click the Right Border option
  12. To see the result, on the Ribbon, click View
  13. In the Show/Hide section, remove the check mark on the Gridlines check box
  14. Save the workbook
  15. Open the DAWN Report2 workbook
  16. Click cell A3 to give it focus
  17. On the Ribbon, click Home. Click the arrow of the Borders button. Click the Bottom Border
  18. Click cell F3
  19. Click the arrow of the Borders button. Click the Bottom Border
  20. Select cells A6:I6
  21. Since the bottom border is already selected on the Borders button, on the Ribbon, just click the Borders button
  22. Save the workbook

The Border Property Page

To better control the borders of a cell or a group of cells, you use the Border property page of the Format Cells dialog box. To access it:

  • On the Ribbon, click Home. In the Font section, the Alignment section, or the Number section, click the more options button 
  • Right-click the cell or the group of selected cells and click Format Cells...

Any of these actions would display the Format Cells dialog box where you would click the Border tab.

Practical Learning: Adding Borders to Cells

  1. The DAWN Report2.xlsx workbook should still be opened.
    Select cells A17:I17
  2. Right-click on the selected cells and click Format Cells...
  3. From the Format Cells dialog box, click the Border property page
  4. From the Line section, in the Style list box, click the 5th line in the right section of the list
  5. Click the Color combo box and select Dark Red
  6. From the Presets section, click the bottom border button
     
    Border
  7. Click OK.
  8. Select cells A2:I2
  9. In the Font section of the Home tab of the Ribbon, click the more options button 
  10. In the Format Cells dialog box, click the Border property page.
    From the Line section, in the Style list box, click the 6th line on the right section of the list
  11. Click the Color combo box and select Blue, Accent1, Lighter 40%
  12. From the Border section, click the top border button
  13. From the Border section, click the left border button
  14. Click the Color combo box and select Dark Blue, Text 2, Darker 25%
  15. From the Border section, click the bottom border
  16. From the Border section, click the right border
     
    Border
  17. Save the workbook