HOW TO: Use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel (288852)

SUMMARY

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

Excel 2002 provides a new approach to adding or removing borders around and between cells. Instead of selecting cells first and then formatting, you can now choose the formatting tool that you want from the new Borders toolbar, and then apply the format to one or more cells.

back to the top

Use the Draw Border Tools

To try an example with the Draw Border tools, follow these steps:

1. Start Excel. On the Formatting toolbar, click the arrow next to the Borders button.
2. Click Draw Borders to display the Borders toolbar.
3. Click the arrow next to the Line Style box, and then select the double line.
4. Click and drag the border tool over the range B3:D14.
   
   A double-line border surrounds the range B3:D14.
5. On the Borders toolbar, click Erase Border.
6. Click and drag the erasing tool over the range of B3:D7.
   
   Notice that the border is removed from the range B3:B7.
7. Click the arrow next to the Draw Border button, and then click Draw Border Grid.
8. On the Borders toolbar, click the Line Color button, and then click Red.
9. Drag over the range B8:D14.
   
   There is a red double-line border around each cell in the range B8:D14.

back to the top