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

Using the Format Cells Dialog Box 165
and shading patterns to cells to draw attention to significant aspects of the spreadsheet.
When adding borders and shading, you can make your job a great deal easier by removing the gridlines used in the Worksheet area to indicate the borders of the cells in the worksheet. To remove these gridlines, deselect the Gridlines check box on the View tab of the Ribbon (or press Alt+WVG) to remove its check mark. After you’ve dispensed with a worksheet’s gridlines, you can immediately tell whether you’ve added the kind of borders that you want and better judge the effect of the color and shading changes that you make.
Note that removing the display of the gridlines in the Workbook window has no effect on the appearance of gridlines in a printed copy of the spread- sheet. If you turn on gridlines for a printout by selecting the Print check box in the Gridlines column of the Sheet Options group on the Page Layout tab (or press Alt+PPG), Excel prints these lines on the printed version of the worksheet even when they do not appear onscreen.
Right on the borderline
When applying borderlines to a cell selection, you have a choice between using the options on the drop-down menu that’s attached to the Borders button in the Font group on the Home tab and using the options on the Border tab of the Format Cells dialog box. You can compare the options offered by each in Figures 2-16 and 2-17. Figure 2-16 shows the border options on the drop-down menu, and Figure 2-17 shows the options on the Border tab of the Format Cells dialog box.
Figure 2-16:
The border options available on the Home tab’s Borders button’s drop-down menu.
Book II Chapter 2
Formatting Worksheets