Apply or remove cell borders

Microsoft Office Excel 2003

Show All 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 Button image on the palette.
  2. Do one of the following:

    ShowApply cell borders

    1. On the Borders toolbar, click the arrow next to Draw Border Button image or Draw Border Grid Button image, 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.

    ShowApply border gridlines

    1. On the Borders toolbar, click the arrow next to Draw Border Button image or Draw Border Grid Button image, and then click Draw Border Grid 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 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.

    ShowRemove 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.