Microsoft KB Archive/105111

= XL: Sorting Feature Ignores Hidden Rows =

Article ID: 105111

Article Last Modified on 1/18/2007

-

APPLIES TO


 * 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

-

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

© Microsoft Corporation. All rights reserved.