XL: Sorting Feature Ignores Hidden Rows

ID: Q105111

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
Microsoft Excel 98 Macintosh Edition

In the versions of Microsoft Excel listed above, the sorting feature will not sort hidden rows or columns. This feature is by design.

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

Additional query words: XL97 XL7 XL5

Keywords : kbdta
Version : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,97; Win95:7.0,7.0a
Platform : MACINTOSH Win95 WINDOWS
Issue type :