Adding Borders to Cells

Adding Borders to Cells

graphics/microsoft24.gif

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

graphics/one_icon.jpg

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

graphics/tow_icon.jpg

Click the Format menu, and then click Cells.

graphics/three_icon.jpg

Click the Border tab.

graphics/foure_icon.jpg

Select a line style.

graphics/five_icon.jpg

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

graphics/six_icon.jpg

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.

graphics/seven_icon.jpg

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

graphics/eight_icon.jpg

Click OK.

graphics/05inf16.jpg

graphics/05inf17.jpg

Apply a Border Using the Formatting Toolbar

graphics/one_icon.jpg

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

graphics/tow_icon.jpg

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.

graphics/three_icon.jpg

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.

graphics/05inf18.jpg

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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net