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

  • Thread starter Thread starter Raj
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Back
Top