How to Remove Gridlines from a Section of a Worksheet

Article translations Article translations
Article ID: 189883 - View products that this article applies to.
This article was previously published under Q189883
Expand all | Collapse all

On This Page

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.

Properties

Article ID: 189883 - Last Review: August 18, 2005 - Revision: 1.3
APPLIES TO
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
Keywords: 
kbhowto KB189883
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com