Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105111

From BetaArchive Wiki
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


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


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