Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

In Excel 2007, you can add borders to certain cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group of the Home tab to add borders of varying styles and colors to any or all sides of the cell selection.

Don’t confuse the borders that you add to accent a particular cell selection with the gridlines normally used to define cell borders in the worksheet — borders that you add are printed whether or not you print the worksheet gridlines. You can remove the display of gridlines by clearing the View check box in the Gridlines section of the Page Layout tab.

Follow these steps to add cell borders:

  1. Select the cells you want to format.

  2. Click the down arrow beside the Borders button in the Font group of the Home tab.

    A drop-down menu appears, with all the border options you can apply to the cell selection.

    Use the Borders button on the Home tab to choose borders for the selected cells.
    Use the Borders button on the Home tab to choose borders for the selected cells.
  3. Click the type of line you want to apply to the selected cells.

    When selecting an option on the Borders drop-down menu, keep these things in mind:

    • To have Excel draw borders only around the outside edges of the entire cell selection, click the Outside Borders or the Thick Box Border option.

    • If you want borderlines to appear around all four edges of each cell you've selected, select the All Borders option.

To change the type of line or line thickness or color of the borders you apply to a cell selection, open the Format Cells dialog box and use the options on its Border tab (click More Borders at the bottom of the Borders button’s drop-down menu or press Ctrl+1 and then click the Border tab).

You’ll find more options for cell borders on the Border tab of the Format Cells dialog box.
You’ll find more options for cell borders on the Border tab of the Format Cells dialog box.

To remove borders in a worksheet, select the cell or cells that presently contain them and then click the No Border option in the Borders button’s drop-down menu.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: