Microsoft KB Archive/150004

= Removing Gridlines in HTML =

Article ID: 150004

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q150004



SUMMARY
When you use the Internet Assistant for Microsoft Excel add-in, gridlines appear in the finished Hypertext Markup Language (HTML) document even if you set the option for the gridlines to not appear or print in Microsoft Excel. This article provides an example of how you can remove these gridlines from the HTML document.



MORE INFORMATION
The add-in discussed in this article is provided "as is" and Microsoft does not guarantee that it can be used in all situations. Although Microsoft support professionals can help with the installation and existing functionality of this add-in, they will not modify the add-in to provide new functionality.

NOTE: Before you can use the following example, you must install the add-in. Please download the file and see the Readme.txt file for the installation instructions.

The add-in discussed in this article can be obtained from the Microsoft TechNet compact disc and from Online Services.

NOTE: The Internet Assistant Wizard add-in ships with Microsoft Excel 97. If you are using Microsoft Excel 97, you do not need to download a copy of the add-in.

For additional information about downloading files from Online Services, please see the following article in the Microsoft Knowledge Base:

119591 : How to Obtain Microsoft Support Files from Online Services

In Microsoft Excel 97
  On a new worksheet, type the following:

  A1: Bill       B1: Clinton A2: George    B2: Bush A3: Ronald    B3: Reagan  Highlight the range from A1 to B3. On the File menu, click Save As HTML. In step 1 of the wizard, the range $A$1:$B$3 appears in the "Ranges and charts to convert" box. Click Next. Accept the default settings in step 2 of the wizard, and click Next. Accept the default settings in step 3 of the wizard, and click Next.</li> In step 4 of the wizard, enter C:\Nogrid.htm in the File Path box.</li></ol>

In Microsoft Excel versions 5.0 and 7.0
<ol>  On a new worksheet, type the following:

<pre class="fixed_text">     A1: Bill       B1: Clinton A2: George    B2: Bush A3: Ronald    B3: Reagan </li> Select the range from A1 to B3.</li> On the Tools menu, click HTML Wizard.</li> In step 1 of the wizard, the range $A$1:$B$3 appears. If it fails to appear, type this range. Click Next.</li> Accept the default settings in step 2 of the wizard, and then click Next.</li> Accept the default settings in step 3 of the wizard, and then click Next.</li> Accept the default settings in step 4 of the wizard, and then click Next.</li> In step 5 of the wizard, enter "C:\Nogrid.htm" (without the quotation marks) as the file path. Click Finish.</li></ol>

Using Internet Explorer to Remove Gridlines
NOTE: This example assumes you have followed the steps in the section "Creating an HTML Document with Gridlines" to create the file C:\Nogrid.htm. If you are using another file name with this example, substitute the path and name of your file for C:\Nogrid.htm.


 * 1) Start Microsoft Internet Explorer. On the File menu, click Open. In the Open box, type C:\Nogrid.htm and click OK.

The data previously entered appears in a table with borders that resemble gridlines.
 * 1) On the View menu, click Source. The HTML formatting codes used to generate the document appear in a Notepad window.
 * 2) Find the line that contains   and delete </Table>.

For additional information, please see the following article in the Microsoft Knowledge Base:

147273 : XL: The Internet Assistant Wizard (html.xla)

Using Microsoft Word to Remove Gridlines
NOTE: This example will create an HTML document using Excel and Word. You must have Word 97 installed on your system in order to use this method.


 * 1) Follow steps 1 and 2 in the "Creating an HTML Document with Gridlines" above.
 * 2) On the Edit menu, click Copy.
 * 3) Start Word. On the Edit menu, click Paste. The Excel data is pasted into Word with the gridlines showing.
 * 4) On the Table menu, click Hide Gridlines.
 * 5) On the File menu, click Save As HTML. In the Save As HTML dialog box, click Save.

When you view the newly created HTML page in a Web browser, the gridlines will no longer appear.

Additional query words: 5.00a 5.00c 5.0 5.0c 97 borders addin IA MS Excel Internet Assistant Wizard

Keywords: kbualink97 KB150004

-

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

© Microsoft Corporation. All rights reserved.