Changing a Worksheet’s Gridlines

Gridlines are the lines on your worksheets that define the cells formed by the intersections of rows and columns. The default gridline color is gray, and not all worksheets work well with this standard setting. Sometimes you’ll want to change the color of the cell gridlines or even turn them off. Excel 2007 also makes it easier than in previous editions to control whether your gridlines appear when you print a worksheet.

Change the Color of Cell Gridlines

  1. Click the Microsoft Office button.

  2. Click Excel Options.

  3. Click Advanced.

  4. Click the Display Options for this Worksheet down arrow.

  5. Select the worksheet, or workbook, to which you want to apply the change.

  6. Click the Gridline Color button.

  7. Select the color you want to use for the gridlines.

  8. Click OK.

    Change the Color of Cell Gridlines

Show or Hide Cell Gridlines

  1. Click the Page Layout tab.

  2. Using the controls in the Sheet Options group on the ribbon, follow either or both of these steps using the check boxes in the Gridlines section of the group:

    • Select the View check box to show the gridlines as you work in Excel or clear the View check box to hide the gridlines as you work.

    • Select the Print check box to show the gridlines when you print the worksheet or clear the Print check box to hide the gridlines when you print.

      Show or Hide Cell Gridlines
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.37.154