Knowledge Base |

# 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