Apply or remove cell borders on a worksheet

1. On a worksheet, select the cell or range of cells that you want to add a border to, change the border style on, or remove a border from.

2. On the Home tab, in the Font group, do one of the following:

   • To apply a new or different border style, select the arrow next to Borders , and then select a border style.

     Tip: To apply a custom border style or a diagonal border, select​​​​​​​ More Borders. In the Format Cells dialog box, on the Border tab, under Line and Color, select the line style and color that you want. Under Presets and Border, select one or more buttons to indicate the border placement. Two diagonal border buttons   are available under Border.

   • To remove cell borders, select the arrow next to Borders , and then select No Border .

• The Borders button displays the most recently used border style. You can select the Borders button (not the arrow) to apply that style.

• If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 acquire a left border.

• If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed.

• A selected range of cells is formatted as a single block of cells. If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5.

• If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:

  1. Select the rows on both sides of the page break.

  2. Select the arrow next to Borders , and then select More Borders.

  3. Under Presets, select the Inside button .

  4. Under Border, in the preview diagram, remove the vertical border by selecting it.

1. On a worksheet, select the cell or range of cells that you want to remove a border from.

   To cancel a selection of cells, select any cell on the worksheet.

2. On the Home tab, in the Font group, select the arrow next to Borders , and then select No Border .

   --OR--

   Select Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

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, select Cell Styles.

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

2. Select New Cell Style.

   

3. In the Style name box, type an appropriate name for the new cell style.

4. Select Format.

5. On the Border tab, under Line, in the Style box, select 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, select the border buttons to create the border that you want to use.

8. Select 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. Select 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, select Cell Styles.

    3. Select the custom cell style that you just created. Like the FancyBorderStyle button in this picture.

       

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. Select Home > the Borders arrow .

2. Pick Draw Borders for outer borders or Draw Border Grid for gridlines.

   

3. Select the Borders arrow > Line Color arrow and then pick a color.

4. Select the Borders arrow > Line Style arrow and then pick a line style.

5. Select cells you want to draw borders around.