There is a quick way to filter by your current selection using Excel. In this case we want to quickly filter for all football World Cups which Brazil have won.

 

 

1. Click on any of the Brazil entries within the ‘Winner’ column
2. Go to File – Options – Customize Ribbon
3. From the ‘Choose commands from’ drop-down, choose ‘Commands Not in the Ribbon’
4. Select AutoFilter and Add and you will be asked to create a new custom group
5. Choose which tab to add your new custom group, name it and move AutoFilter across into it

The data will have now filtered to the current selection, Brazil.