Apply or remove cell borders in Excel 2007 tables

　　In Excel 2007 , you can use predefined border styles to make two or more cells in a cell or range of cells Range: a worksheet. Cells in a range can be contiguous or nonadjacent. To quickly add a border around it.

1. On the worksheet, select the cell or range of cells that you want to add a border to, change the border style, or delete a border.

　　tip to deselect a range of cells, click any cell in the worksheet.

2, on the Start tab, in the Font group, do one of the following:

• To apply a new style or other border style, click the arrow next tothe border%20, and then click the border style.

　　 Tip%20 to apply a custom border style or a diagonal border, click More borders. On the Borders tab, under Lines and colors, click the line style and color that you want. Under Presets and borders, click one or more buttons to indicate the border position. Under "Border" there are two oblique border buttons%20 and.

To remove a cell border, click the arrow next to Border, and then click No border.

　　

　　Comments

·“ Border button to display the most recently used border style. You can apply the style by clicking the Border button (not an arrow).

• If you apply a border to a selected cell, the border also applies to adjacent cells that share a cell border. For example, if you apply a text box border to surround the area b1:c5, cell D1:d5 will have the left border.

• Displays the most recently applied border if you apply two different border types to a shared cell border.

• The selected range of cells is formatted as a complete block of cells. If you apply the right border to the cell range b1:c5, the border appears only on the right side of cell c1:c5.

• If you want to print the same border on a cell separated by a page break, but have the border appear only on one page, you can apply an inner box line. This allows you to print a border at the bottom of the last line of a page and use the same border at the top of the first row of the next page. Do the following:

1 Select the rows on both sides of the page break.

2 Click the arrow next to Border, and then click More borders.

3 under Preset, click the internal button .

4 in the preview graphic below the border, click to remove the vertical border.