Knowledge Base

XL: Sorting Feature Ignores Hidden Rows

Article ID: 105111

Article Last Modified on 1/18/2007

Microsoft Excel 2000 Standard Edition
Microsoft Excel 2002 Standard Edition
Microsoft Excel 97 Standard Edition
Microsoft Excel 95 Standard Edition
Microsoft Excel 95a
Microsoft Excel 5.0 Standard Edition
Microsoft Excel 5.0c
Microsoft Excel 98 for Macintosh
Microsoft Excel 5.0 for Macintosh
Microsoft Excel 5.0a for Macintosh

This article was previously published under Q105111

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, the sorting feature does not sort hidden rows or columns.

MORE INFORMATION

Earlier versions of Microsoft Excel did allow you to sort hidden rows; however, this capability often produced undesired results.

Additional query words: XL97 XL7 XL5 XL2000 XL2002

Keywords: kbprb KB105111