maintaing headers in sort

K

kww

I am trying to maintain a header of two lines whilst still being able t
sort the contents - freezing and/or locking do not work as they seem t
prevent the use of sort.
Any ideas
 
B

Bob Umlas, Excel MVP

Select all the cells you want to use in the sort -- that is, simply exclude
the 2 rows you don't want sorted.
 
Top