Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

Summary

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.

↑ Back to the top


Keywords: KB213884, kbhowtomaster, kbhowto

↑ Back to the top

Article Info
Article ID : 213884
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 250