header row

[Bridgettesmom]

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.

 

[Francis]

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

 

[Niek Otten]

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