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.

Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291 © 2008-2017.
If you may any questions please contact us: