Apply or remove cell borders

From Microsoft Office Excel 2003

Show All

Apply or remove cell borders

  1. On the Formatting toolbar, click the arrow next to Borders Button image, and then click Draw Borders on the palette.
  2. Do one of the following:

    Apply cell borders

    1. On the Borders toolbar, click the arrow next to Draw Border Button image or Draw Border Grid , and then click Draw Border Button image on the palette.
    2. Do one of the following:

      Draw a border line on cells    Click the line you want as a border with the border drawing tool Button image or click on the line and drag on the lines you want as borders.

      Draw an outside border around a row    Click in the center of a cell with the border drawing tool Button image and drag on the row.

      Draw an outside border around a column    Click in the center of a cell with the border drawing tool Button image and drag on the column.

    Apply border gridlines

    1. On the Borders toolbar, click the arrow next to Draw Border Button image or Draw Border Grid , and then click Draw Border Grid on the palette.
    2. Do one of the following:

      Draw a border line on cells    Click the line you want as a border with the border grid drawing tool Button image or click on the line and drag on the lines you want as borders.

      Draw borders around every cell in a row    Click in the center of a cell with the border grid drawing tool Button image and drag on the row.

      Draw borders around every cell in a column    Click in the center of a cell with the border grid drawing tool Button image and drag on the column.

    Notes

    • To apply a different border line style, click the arrow next to Line Style Button image, and then click a line style on the palette.
    • To apply a different border line color, click Line Color Button image, and then click a color on the palette.
    • The borders are applied to the edges of the cells, which are rotated to the same degree as the rotated text.
    • Holding the CTRL key temporarily toggles between Draw Border mode and Draw Border Grid mode and also toggles the Erase Border mode between erase borders and erase border grids.

    Remove borders

    1. On the Borders toolbar, click Erase Border Button image on the palette.
    2. Do one of the following:

      Delete a single border    Click the border you want to delete with the eraser tool Button image.

      Delete more than one border    Drag the eraser tool Button image over the borders you want to delete.

    Note  Holding the CTRL key temporarily toggles the Erase Border mode between erase borders and erase border grids.