Thread: why does excel not recognise row 1 as a header row when sorting?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
  
Posts: 2,345
Default why does excel not recognise row 1 as a header row when sorting?
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


 with @tiscali.co.uk


Reply With QuoteReply With Quote