Page 184 - Excel 2013 All-in-One For Dummies

166 Using the Format Cells Dialog Box
Figure 2-17:
The border options available on the Border tab of the Format Cells dialog box.
To apply borders to the cell selection by using the options on the Borders button’s drop-down menu, choose the option on the menu with the type of border you want drawn. To remove a borderline that you select in error, simply choose the No Border option at the top of this drop-down menu.
While defining the borderlines to apply in the Border tab, you can select a new style for the borderlines by clicking the Line style in the Style sample area. To select a new color (besides boring old black) for the borderlines that you’re about to apply, click the swatch of the new color you want to use in the Color drop-down palette.
When using the Borders palettes to assign borderlines to a cell selection, your options are limited to just the Border buttons displayed on the pal- ette. This means that you don’t have as much choice in terms of line style and type of borderlines. (In other words, you can’t be applying any dashed diagonal borderlines from this palette.) You also can’t change the color of the borderlines from the Borders palette.
Keep in mind that the Borders button’s drop-down menu includes a couple of options that enable you to literally draw borders around a cell selection in your worksheet by dragging the mouse pointer through the cells. Choose the Draw Border option to draw a border just outlining the cells you select or Draw Border Grid to draw borders around each and every cell you select with the mouse.
To get rid of borderlines that you’ve added to a cell range, no matter which method you used to add them, select the range and then choose the No Border option from the Borders button’s drop-down menu.