Feb 21 2022 09:28 PM
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
Feb 21 2022 11:43 PM
SolutionHi @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.
Alternatively, activate the multi-select option and you can also select multiple entries without pressing Ctrl-key:
Feb 22 2022 07:19 PM
Feb 21 2022 11:43 PM
SolutionHi @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.
Alternatively, activate the multi-select option and you can also select multiple entries without pressing Ctrl-key: