View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JoeSpareBedroom JoeSpareBedroom is offline
external usenet poster
 
Posts: 87
Default why does excel not recognise row 1 as a header row when sorting?

"Sandy Mann" wrote in message
...
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.



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