Microsoft KB Archive/221073

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

Article ID: 221073

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q221073



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 () tag, similar to the following example:



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:
 * 1) Save the file by clicking Save As on the File menu, and giving the file a new name.
 * 2) In the file you created in step 1, delete the columns or rows you want to hide.
 * 3) 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: kbprb KB221073

-

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

© Microsoft Corporation. All rights reserved.