MS Excel Internet Assistant Wizard: Removing Gridlines in HTML

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, version 5.x
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for the Macintosh, version 5.0, 5.0a

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 engineers 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:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

Creating an HTML Document with Gridlines

In Microsoft Excel 97

1. On a new worksheet, type the following:

      A1: Bill       B1: Clinton
      A2: George     B2: Bush
      A3: Ronald     B3: Reagan
   
   

2. Highlight the range from A1 to B3.

3. On the File menu, click "Save as HTML...".

4. In step 1 of the wizard, the range $A$1:$B$3 appears in the "Ranges and charts to convert:" box. Click Next.

5. Accept the default settings in step 2 of the wizard, and click Next.

6. Accept the default settings in step 3 of the wizard, and click Next.

7. In step 4 of the wizard, enter C:\Nogrid.htm in the File Path box.

In Microsoft Excel versions 5.0 and 7.0

1. On a new worksheet, type the following:

         A1: Bill       B1: Clinton
         A2: George     B2: Bush
         A3: Ronald     B3: Reagan
   
   

2. Select the range from A1 to B3.

3. On the Tools menu, click HTML Wizard.

4. In step 1 of the wizard, the range $A$1:$B$3 appears. If it fails to appear, type this range. Click Next.

5. Accept the default settings in step 2 of the wizard, and then click Next.

6. Accept the default settings in step 3 of the wizard, and then click Next.

7. Accept the default settings in step 4 of the wizard, and then click Next.

8. In step 5 of the wizard, enter "C:\Nogrid.htm" (without the quotation marks) as the file path. Click Finish.

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 Address box, type C:\Nogrid.htm and click OK.

   The data previously entered appears in a table with borders that resemble gridlines.

2. On the View menu, click Source. The HTML formatting codes used to generate the document appear in a Notepad window.

3. Find the line that contains <Table border>. Change <Table border> to <Table> by deleting the word "border" from within the angle brackets.

4. On the File menu in Notepad, click Save.

5. On the File menu in Notepad, click Exit.

6. On the View menu of Internet Explorer, click Refresh. The Microsoft Excel data now appears in a table format, with no gridlines.

   Find the line that contains <Table border> and delete <Table border>.
   Find the line that contains </Table> and delete </Table>.

   ARTICLE-ID: Q147273
   TITLE     : The Internet Assistant Wizard for Microsoft Excel (html.xla)