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
This article has been archived. It is offered "as is" and will no longer be updated.
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: 12/05/2015 12:22:27 - Revision: 3.1

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbhowtomaster KB213884