Excel sort dialog box: Display of column header instead of columnname

[Raj]

Hi,

Data in Column A has the header "Salesman". When the Sort dialog box
is invoked, it now displays "Column A" for the "sort by" box instead
of "Salesman". Previously, it was displaying the column header ie.
"Salesman". Is there any setting to ensure that the column header is
displayed instead of the column name?

Thanks in advance for the help.

Regards,
Raj

 

[trip_to_tokyo]

Hi,

Data in Column A has the header "Salesman". When the Sort dialog box
is invoked, it now displays "Column A"  for the "sort by" box instead
of "Salesman". Previously, it was displaying the column header ie.
"Salesman".  Is there any setting to ensure that the column header is
displayed instead of the column name?

Thanks in advance for the help.

Regards,
Raj

EXCEL 2007

In the Sort Dialogue Box place a tick (check) in the:-

My data has headers

- box towards the top right hand corner.

Please rate my post if possible.

Thanks.