HOW TO: Hide Gridlines in a Selected Area of a Worksheet in Excel 2000 (213884)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q213884
For a Microsoft Excel 97 and earlier version of this article, see 189883.

IN THIS TASK

SUMMARY

This article describes how to hide the gridlines in a selected area of a worksheet in Excel 2000.

back to the top

Hide Gridlines

To hide gridlines in a selected area of a worksheet, follow these steps:
  1. Select the range of cells for which you want to hide the gridlines.
  2. On the Format menu, click Cells.
  3. Click the Patterns tab, and then click the color that matches the background color of your worksheet (typically, white).

    This hides the gridlines on all four sides of each cell in the selected area.
  4. To restore the gridlines around the perimeter of the selected area, click the Border tab. In the Color list, click the color that matches the color of the gridlines on your worksheet (typically, gray-25%), and then click Outline.
  5. Click OK.
The gridlines are hidden in the selected area of the worksheet.

back to the top

Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbhowto kbHOWTOmaster KB213884