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.

Apply a Border Using the Formatting Toolbar

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

Click the Borders list arrow on the Formatting toolbar or the Borders button to select the default border style. If necessary, click the Toolbar Options list arrow to display the button.

Select a border from the submenu of available borders. The previous border style you have chosen appears as the default Borders button on the Formatting toolbar.

Did You Know?

You can use the Select All button . To place a border around the entire worksheet, click the Select All button, and then apply the border.