Filter by current selection in Excel

FilterCurrentSelection1

 

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.

 

FilterCurrentSelection2

 

  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.

 

FilterCurrentSelection3

Leave a Reply

Your e-mail address will not be published. Required fields are marked *