? Issue: Unable to place DATA/Filter selector in 2nd data row;

Copper Contributor

Goal:  I need to FILTER Data Records starting in row #3 

 

 I have a table with 2 header rows (see image attached): {Row#1 & Row#2). i.e. my dataset records actually start in Row#3

 

ISSUE: When I insert the FILTER button into a single column in Row#2, Excel defaults back, and forces the Filter Button into Row#1 (NOT DESIRED). 

 

Excel 2020 (latest desktop version)

 

 

 

 

1 Reply

resolved?  // It appears that I can not insert a 'single' Filter button into Row #2 column, however, I can overcome this limitation by selecting the entire row then activating the FILTER button in all columns.

 

not a big deal ;)