Forum Discussion

OliverKody's avatar
OliverKody
Copper Contributor
Mar 06, 2020

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

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)

 

 

 

 

excel

1 Reply

  • OliverKody's avatar
    OliverKody
    Copper Contributor
    Mar 06, 2020

    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 😉  

     

     

Resources