Home

data filter

%3CLINGO-SUB%20id%3D%22lingo-sub-612776%22%20slang%3D%22en-US%22%3Edata%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612776%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%20..%3CBR%20%2F%3EI%20need%20to%20filter%20the%20data%20by%20color%20but%20when%20I%20press%20the%20filter%20button%20the%20menu%20is%20not%20activated%3F%20!!%20A%20message%20at%20the%20bottom%20of%20the%20list%20does%20not%20show%20all%20the%20elements.%3CBR%20%2F%3ENote%3A%20The%20number%20of%20data%20in%20the%20file%20is%20more%20than%2010%2C000%20cells%3C%2FP%3E%3CP%3Esee%20the%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-612776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614044%22%20slang%3D%22en-US%22%3ERe%3A%20data%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344493%22%20target%3D%22_blank%22%3E%40bayatee%3C%2FA%3E%26nbsp%3B%2C%20it's%20grayed%20since%20it's%20nothing%20to%20filter%2C%20all%20cells%20in%20the%20column%20are%20in%20same%20color.%20If%20change%20a%20bit%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20253px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114307i9320EC934CA67D8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewhen%20filter%20option%20appears%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20430px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114308iF49519A77404DF89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
bayatee
Occasional Visitor

Hi there ..
I need to filter the data by color but when I press the filter button the menu is not activated? !! A message at the bottom of the list does not show all the elements.
Note: The number of data in the file is more than 10,000 cells

see the attached file

1 Reply

@bayatee , it's grayed since it's nothing to filter, all cells in the column are in same color. If change a bit

image.png

when filter option appears

image.png

Related Conversations