Have you try
click Data
select Sort
click Header row under My data range

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Bridgettesmom" wrote:

I am trying to resort and subtotal an old worksheet, but no matter what I do,
I cannot get excel to recognize the first row as a header row.