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: Defined Names Not Sorted in Excel

View products that this article applies to.

This article was previously published under Q58245

↑ Back to the top


Named ranges that are included within a Sort area do not change when the area is sorted. The defined names still refer to their original references.

↑ Back to the top

More information

Defined names refer to a cell reference and not to the cell contents specifically. When performing a Data Sort, you are only sorting the contents of the cells. Because of this, a defined name may not be referencing the same data after a sort.

↑ Back to the top

Keywords: KB58245, kbinfo

↑ Back to the top

Article Info
Article ID : 58245
Revision : 3
Created on : 1/18/2007
Published on : 1/18/2007
Exists online : False
Views : 476