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