In this article, we will illustrate the use of the filter through a simple example (mentioned here under).
1- Select the data that you want to filter.
2- On the Data tab, click Filter in the Filter & Sort.
Shortcut key alert: To do the same Press Alt + A + T.
Arrows in column headers will appear.
3- Click the arrow in the column header (in our example, we will filter visits made to UK only)
4- Select UK option only from the appeared Filter menu and press OK.
Result. Excel will show visits made to UK only.
Remove a Filter
To remove the filter, press again Alt + A + T or Click Clear in the Sort & Filter section.
Filter by searching value
Filter by specifying conditions