Adding Borders to Cells

Adding Borders to Cells

The light gray grid that appears on the worksheet helps your eyes move from cell to cell. Although you can print these gridlines, sometimes a different grid pattern better emphasizes your data. For example, you might put a decorative line border around the title, a double-line bottom border below cells with totals, or a thick border between sections of a complicated worksheet. You can add borders of varying colors and widths to any or all sides of a single cell or range.

Apply a Border

Select a cell or range to which you want to apply borders.

Click the Format menu, and then click Cells.

Click the Border tab.

Select a line style.

Click the Color list arrow, and then click a color for the border.

If you want a border on the outside of a cell or range, click Outline. If you want a border between cells, click Inside. If you want to remove a border, click None.

To set a custom border, click a Border button, or click the Preview Border box where you want to add a border.

Click OK.

Did You Know?

You can apply a border using the Formatting toolbar . Select a cell or range to which you want to apply a border, Click the Borders button list arrow on the Formatting toolbar to select a border. The most recently selected style displays on the Borders button.