Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1213832%22%20slang%3D%22en-US%22%3ERe%3A%20%3F%20Issue%3A%20Unable%20to%20place%20DATA%2FFilter%20selector%20in%202nd%20data%20row%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213832%22%20slang%3D%22en-US%22%3E%3CP%3Eresolved%3F%26nbsp%3B%20%2F%2F%20It%20appears%20that%20I%20can%20not%20insert%20a%20'single'%20Filter%20button%20into%20Row%20%232%20column%2C%20%3CEM%3Ehowever%3C%2FEM%3E%2C%20I%20can%20overcome%20this%20limitation%20by%20selecting%20the%20%3CU%3Eentire%20row%3C%2FU%3E%20then%20activating%20the%20FILTER%20button%20in%20all%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enot%20a%20big%20deal%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1213784%22%20slang%3D%22en-US%22%3E%3F%20Issue%3A%20Unable%20to%20place%20DATA%2FFilter%20selector%20in%202nd%20data%20row%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1213784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EGoal%3A%3C%2FSTRONG%3E%26nbsp%3B%20I%20need%20to%20FILTER%20Data%20Records%20starting%20in%20row%20%233%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20a%20table%20with%20%3CU%3E%3CSTRONG%3E2%3C%2FSTRONG%3E%20%3C%2FU%3Eheader%20rows%20(see%20image%20attached)%3A%20%7BRow%231%20%26amp%3B%20Row%232).%20i.e.%20my%20dataset%20records%20actually%20start%20in%20%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3ERow%233%3C%2FSTRONG%3E%3C%2FFONT%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EISSUE%3C%2FSTRONG%3E%3A%20When%20I%20insert%20the%20FILTER%20button%20into%20a%20single%20column%20in%20Row%232%2C%20Excel%20defaults%20back%2C%20and%20forces%20the%20Filter%20Button%20into%20Row%231%20(%3CFONT%20color%3D%22%23FF0000%22%3ENOT%20DESIRED%3C%2FFONT%3E).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%202020%20(latest%20desktop%20version)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1213784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New 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
Highlighted

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