SOLVED

How to filter for multiple things in a table at once?

%3CLINGO-SUB%20id%3D%22lingo-sub-3196795%22%20slang%3D%22en-US%22%3EHow%20to%20filter%20for%20multiple%20things%20in%20a%20table%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3196795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20quickly%20filter%20a%20long%20list%20of%20countries%20with%20only%20the%20select%20few%20countries%20that%20I'm%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20need%20to%20manually%20type%20each%20country%20with%20text%20filter%20but%20wanted%20to%20check%20if%20there's%20a%20more%20efficient%20method.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20excel%20sample%20for%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EAmy%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3196795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3197312%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20for%20multiple%20things%20in%20a%20table%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3197312%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1260738%22%20target%3D%22_blank%22%3E%40AmyYang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20there%20is%20a%20more%20comfortable%20way.%3C%2FP%3E%3CP%3EConvert%20the%20list%20of%20countries%20into%20a%20formatted%20table%3A%20menue%20%22Start%20%7C%20Format%20as%20Table%22%3C%2FP%3E%3CP%3EThen%20insert%20a%20slicer%3A%20menu%20%22Insert%20%7C%20Slicer%22%3C%2FP%3E%3CP%3EAs%20the%20table%20has%20got%20only%20one%20column%2C%20select%20the%20country-field%20for%20the%20Slicer.%3C%2FP%3E%3CP%3EThe%20Slicer%20is%20always%20visible%20and%20you%20can%20move%20it%20around.%20If%20you%20hold%20the%20Ctrl-key%2C%20then%20you%20can%20select%20several%20countries.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_0-1645515758834.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350240iA50E249BA43E0103%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_0-1645515758834.png%22%20alt%3D%22DTE_0-1645515758834.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAlternatively%2C%20activate%20the%20multi-select%20option%20and%20you%20can%20also%20select%20multiple%20entries%20without%20pressing%20Ctrl-key%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_1-1645515817416.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350241i0E3D2F779708D29C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_1-1645515817416.png%22%20alt%3D%22DTE_1-1645515817416.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3202097%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20for%20multiple%20things%20in%20a%20table%20at%20once%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202097%22%20slang%3D%22en-US%22%3EDear%20DTE%2C%3CBR%20%2F%3EThanks%20so%20much%20for%20your%20reply%20and%20detailed%20response%20on%20instructions%20for%20using%20this!%20I%20just%20tried%20it%20and%20it%20works%20great!%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20had%20to%20select%2025%20different%20countries%20though%2C%20I%20guess%20the%20only%20limitation%20is%20that%20I%20still%20need%20to%20select%20all%20the%20countries%20from%20the%20list%2C%20it%20wouldn't%20be%20able%20to%20automatically%20select%20and%20filter%20it.%20But%20I%20think%20that's%20okay%20given%20still%20much%20faster%20than%20typing%20it%20manually%20one-by-one!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%2C%3CBR%20%2F%3EAmy%3C%2FLINGO-BODY%3E
Contributor

Hi,

I would like to quickly filter a long list of countries with only the select few countries that I'm looking for.

 

Currently I need to manually type each country with text filter but wanted to check if there's a more efficient method. 

 

I have attached excel sample for example.

 

Thank you,

Amy 

2 Replies
best response confirmed by AmyYang (Contributor)
Solution

Hi @AmyYang 

 

yes, there is a more comfortable way.

Convert the list of countries into a formatted table: menue "Start | Format as Table"

Then insert a slicer: menu "Insert | Slicer"

As the table has got only one column, select the country-field for the Slicer.

The Slicer is always visible and you can move it around. If you hold the Ctrl-key, then you can select several countries.

DTE_0-1645515758834.png

Alternatively, activate the multi-select option and you can also select multiple entries without pressing Ctrl-key:

DTE_1-1645515817416.png

 

Dear DTE,
Thanks so much for your reply and detailed response on instructions for using this! I just tried it and it works great!

If I had to select 25 different countries though, I guess the only limitation is that I still need to select all the countries from the list, it wouldn't be able to automatically select and filter it. But I think that's okay given still much faster than typing it manually one-by-one!

Thank you,
Amy