Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL: Sorting Feature Ignores Hidden Rows

View products that this article applies to.


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

↑ Back to the top

More information

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

↑ Back to the top

Keywords: kbprb, KB105111

↑ Back to the top

Article Info
Article ID : 105111
Revision : 5
Created on : 1/18/2007
Published on : 1/18/2007
Exists online : False
Views : 507