Microsoft KB Archive/213884

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

Article ID: 213884

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213884



For a Microsoft Excel 97 and earlier version of this article, see 189883.

IN THIS TASK
SUMMARY
 * Hide Gridlines



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.
 * 1) 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.
 * 2) Click OK.

The gridlines are hidden in the selected area of the worksheet.

back to the top

Additional query words: XL2000

Keywords: kbhowto kbhowtomaster KB213884

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.