Or format the header differently; Often Excel will recognize it as a header
row

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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