why does excel not recognise row 1 as a header row when sorting?

S

Sandy Mann

I think that it is because Excel does not *see* the row as a header. Try
formatting the heder row to be fifferent to the data.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
J

JoeSpareBedroom

Sandy Mann said:
I think that it is because Excel does not *see* the row as a header. Try
formatting the heder row to be fifferent to the data.
Click to expand...


The sort dialog box contains an option to tell Excel whether or not to
include the header in the sort.
 
Top