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

Article translations Article translations
Article ID: 288852 - View products that this article applies to.
This article was previously published under Q288852
Expand all | Collapse all

On This Page

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.
  5. In the Font group on the Home tab, click the arrow next to the Borders button, and then click Erase Border.
  6. Click and then drag the erasing tool over the range of B3:D7.

    Notice that the border is removed from the range B3:B7.
  7. In the Font group on the Home tab, click the arrow next to the Borders button, point to Line Color, and then click Red.
  8. In the Font group on the Home tab, click the arrow next to the Borders button, and then click Draw Border Grid.
  9. 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.
  6. On the Borders toolbar, click Erase Border.
  7. Click and then drag the erasing tool over the range of B3:D7.

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

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

Properties

Article ID: 288852 - Last Review: March 28, 2007 - Revision: 2.1
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbformat kbexpertisebeginner kbhowtomaster KB288852

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com