Originally Posted by Aquinax

I'm using the command Advanved Filter to filter out duplicate data entries quite frequently and it pains me to every stipulate the header for a row of data as the program asks to do. Yet sometimes it(Excel) goes about this filtering business without pestering me about its need for a header. And does it without fault (the first row is included in the data to be filtered and is not treated as a header). So I'm asking those more experienced - is it possible to 'tell' the program to never ask me for a header when Advanced Filtering and always treat the first row as a header?