View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHJ IN AZ
 
Posts: n/a
Default EXCEL SORT - How do I prevent 'frozen' rows from sorting?

(Excel 2000) I have 2 "header rows" that I don't want included when I sort
the page. It worked fine at first, just clicking the sort ascending or sort
descending icon, then something changed. Even if I go to "data sort" and
check "header row" it only recognizes the top row, not the second. I've had
this happen before but can't remember the cure.