XL: Sorting Feature Ignores Hidden Rows (105111)



The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 95 7.0a
  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel 98 Macintosh Edition
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for the Macintosh 5.0a

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.

Modification Type:MinorLast Reviewed:8/15/2005
Keywords:kbprb KB105111