Equity & Help Inc

You can create a cell style that includes a custom border, and then you can apply that cell style when you want to display the custom border around selected cells.

1. On the Home tab, in the Styles group, click Cell Styles.

Tip: If you do not see the Cell Styles button, click Styles, and then click the More button next to the cell styles box.

2. Click New Cell Style.

3. In the Style name box, type an appropriate name for the new cell style.
4. Click Format.
5. On the Border tab, under Line, in the Style box, click the line style that you want to use for the border.

6. In the Color box, select the color that you want to use.
7. Under Border, click the border buttons to create the border that you want to use.
8. Click OK.
9. In the Style dialog box, under Style Includes (By Example), clear the check boxes for any formatting that you do not want to include in the cell style.
10. Click OK.
11. To apply the cell style, do the following:
    1. Select the cells that you want to format with the custom cell border.
    2. On the Home tab, in the Styles group, click Cell Styles.
    3. Click the custom cell style that you just created. Like the FancyBorderStyle button in this picture.

Draw Cell Borders

To customize the line style or color of cell borders or erase existing borders, you can use the Draw Borders options. To draw cell borders, you'll first select the border type, then the border color and line style, and select the cells that you want to add a border around. Here's how:

1. Click Home > the Borders arrow .
2. Pick Draw Borders for outer borders or Draw Border Grid for gridlines.

3. Click the Borders arrow > Line Color arrow, and then pick a color.
4. Click the Borders arrow > Line Style arrow, and then pick a line style.
5. Select cells you want to draw borders around.