You are currently offline, waiting for your internet to reconnect

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

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


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

Article ID: 213884 - Last Review: 09/27/2003 14:00:31 - Revision: 3.1

  • Microsoft Excel 2000 Standard Edition
  • kbhowto kbhowtomaster KB213884