Microsoft KB Archive/288852

= How to use Draw Border tools and Draw Border Grid tools to apply and remove cell borders in Excel =

Article ID: 288852

Article Last Modified on 3/28/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q288852





SUMMARY
This step-by-step article shows an example of how you can use the Draw Border tools and the Draw Border Grid tools in Microsoft Excel.

Excel provides a method to add or to remove borders around and between cells. Instead of selecting cells first and then formatting, you can choose the formatting tool that you want to use, and then apply the format to one or more cells.

Microsoft Office Excel 2007
To try an example that uses the Draw Border tools and the Draw Border Grid tools, follow these steps:
 * 1) Start Excel.
 * 2) In the Font group on the Home tab, click the arrow next to the Borders button, point to Line Style and then click the double line style.
 * 3) In the Font group on the Home tab, click the arrow next to the Borders button, and then click Draw Border.
 * 4) Click and then drag the border tool over the range B3:D14.

A double-line border surrounds the range B3:D14.
 * 1) In the Font group on the Home tab, click the arrow next to the Borders button, and then click Erase Border.
 * 2) Click and then drag the erasing tool over the range of B3:D7.

Notice that the border is removed from the range B3:B7.
 * 1) In the Font group on the Home tab, click the arrow next to the Borders button, point to Line Color, and then click Red.
 * 2) In the Font group on the Home tab, click the arrow next to the Borders button, and then click Draw Border Grid.
 * 3) Drag the mouse pointer over the range B8:D14.

There is a red double-line border around each cell in the range B8:D14.

Microsoft Office Excel 2003 and Microsoft Excel 2002
To try an example that uses the Draw Border tools and the Draw Border Grid tools, follow these steps:
 * 1) Start Excel.
 * 2) On the Formatting toolbar, click the arrow next to the Borders button.
 * 3) Click Draw Borders to display the Borders toolbar.
 * 4) Click the arrow next to the Line Style box, and then select the double line.
 * 5) Click and then drag the border tool over the range B3:D14.

A double-line border surrounds the range B3:D14.
 * 1) On the Borders toolbar, click Erase Border.
 * 2) Click and then drag the erasing tool over the range of B3:D7.

Notice that the border is removed from the range B3:B7.
 * 1) Click the arrow next to the Draw Border button, and then click Draw Border Grid.
 * 2) On the Borders toolbar, click the Line Color button, and then click Red.
 * 3) Drag the mouse pointer over the range B8:D14.

There is a red double-line border around each cell in the range B8:D14.

Additional query words: OfficeKBHowTo inf XL2002 XL2003 XL2007

Keywords: kbformat kbexpertisebeginner kbhowtomaster KB288852

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.