XL: How to Remove Gridlines from a Section of a Worksheet

ID: Q189883

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, version 7.0

SUMMARY

This article describes how to hide the gridlines on a section of a worksheet in Microsoft Excel.

MORE INFORMATION

Follow the steps for your version of Microsoft Excel.

Microsoft Excel 97

1. Select the range of cells that you want to remove the gridlines from.

2. On the Format menu, click Cells.

3. In the Format Cells dialog box, click the Patterns tab. Click to

   select the color that matches the background color of your worksheet
   (usually White).

4. Click the Border tab. Click the arrow in the Color box, click the color

   that matches the color of the gridlines on your worksheet (usually
   Gray-25%), and then click Outline.

5. Click OK.

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

Microsoft Excel 7.0

1. Select the range of cells that you want to remove the gridlines from.

2. On the Format menu, click Cells.

3. In the Format Cells dialog box, click the Patterns tab. Click to select

   the color that matches the background color of your worksheet (usually
   White).

4. Click the Border tab. Click the arrow in the Color box, and click the

   color that matches the color of the gridlines on your worksheet.
   Usually, this is the second color from the right in the second row of
   colors.

5. Click the second box on the left side of the Style section of the

   border tab to select a border style. Click the Outline box in the Border
   section of the Border tab.

6. Click OK.

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

For additional information about hiding gridlines in earlier versions of Excel, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q96933
   TITLE     : Excel: Removing Gridlines from a Section of a Worksheet

Additional query words: XL97 7.0

Keywords          : kbdta xlui xlformat 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS
Issue type        : kbhowto

Last Reviewed: January 9, 1999