XL2000: Hidden Rows and Columns Are Displayed in Some Web Browsers

ID: Q221073

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you save an Excel worksheet containing hidden rows or columns as a Web page and then view the file in a Web browser, hidden rows and columns may or may not be displayed depending on which Web browser you are using.

The following table describes whether hidden rows or columns are displayed based on your Web browser:


If you are using this browser       Hidden rows/columns are displayed
-------------------------------------------------------------------------

Internet Explorer 5                 No
Internet Explorer 4                 Blank rows and columns may be 
                                    displayed.
Internet Explorer 3                 Yes
Netscape Navigator 4                Data in hidden columns is 
                                    displayed. Data in hidden rows is 
                                    not displayed; however, blank rows may
                                    be displayed.
Netscape Navigator 3                Yes

CAUSE

This behavior occurs if your browser does not support the Cascading Style Sheet (CSS) Level 2 specification. When saving a worksheet that contains hidden rows and columns, Excel saves information about the hidden rows and columns in the display property of the style attribute of the table row (<TR>) tag, similar to the following example:

<tr height=0 style='display:none'>

The display property is based on the CSS Level 2 specification. display:none indicates that no boxes should be displayed. Therefore, if your browser does not support the CSS Level 2 specification, it may display the hidden columns or rows partially or entirely. This is a limitation of the browser, not of Excel. Note that Microsoft Internet Explorer 5 does support the CSS Level 2 specification.

WORKAROUND

To work around this behavior, follow these steps:

Save the file by clicking Save As on the File menu, and giving the file a new name.

In the file you created in step 1, delete the columns or rows you want to hide.

Save the file by clicking Save as Web Page on the File menu. Excel gives the file an .htm extension.

When you view the page in any browser, the columns or rows you deleted aren't displayed because they were not saved in the HTML file.

MORE INFORMATION

For additional information about the Cascading Style Sheets, Level 2 specification, please see the following Web site:

http://www.w3.org/TR/REC-CSS2/

Additional query words: XL2000 hide hiding appears displaying showing shows

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb