Title row

[Estam]

I seemed to have touched something here. My first row lists m
descriptions and now when I sort, it also sorts. Can anyone please tel
me what the key is to keep this row on top. Many thanks ......Dav

 

[Spencer101]

I seemed to have touched something here. My first row lists m
descriptions and now when I sort, it also sorts. Can anyone please tel
me what the key is to keep this row on top. Many thanks ......Dave

Ensure you have headers in all used columns in row 1 and make them bold
Works for me! :

 

[Gord Dibben]

In the Sort Options place a checkmark in "my data range has" header
row.

If you make the text in the Title row bold or different font than the
others, Excel will most times see that as a header row automatically.


Gord

 

[Estam]

Thank you, perfect...