Using Filters with the Consortia Builder

Information by State  Print version

Auto Filtering has been applied to the column headings in the Consortia Builder Excel Spreadsheets. This will make it easier for you to work with the data contained in the worksheets.

To filter for specific values:

1. Click the drop-down arrow next to the column header that contains the value you want to display.
2. Select the value you want to filter for.
   
   
   
   
   
   Only the rows that contain the value you chose will display; the rest will be hidden. The rows that remain visible will have their corresponding row numbers highlighted in blue. The drop-down arrow also turns blue.
   
   
   
   
   
3. To filter for more values, click the blue drop-down arrow next to another column header to hide more even more rows from your original selection
4. To reverse the filtering, click the blue drop-down arrow again, and select (All).