Data Filter

[palaeontology]

Hi, when I set up a standard data filter on a sheet, the filter drop arrows automatically appear in row 1 of each relevant column.

Is there a way to have them appear, or begin their filtering process, from, let's say, row 4 .... because i have rows 1 through 3 containing headings and sub-headings that need to remain visible when filtering.

Kind regards,

Chris

 

[Fluff]

Just select row 4 before selecting autofilter