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

Article translations Article translations
Article ID: 213884 - View products that this article applies to.
This article was previously published under Q213884
Expand all | Collapse all

On This Page


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

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.


Article ID: 213884 - Last Review: September 27, 2003 - Revision: 3.1
  • Microsoft Excel 2000 Standard Edition
kbhowto kbhowtomaster KB213884

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from