HUD Logo
USA Flag  
Connect with HUD
HUD Mobile HUD Podcasts HUD Wiki
Site Map         A-Z Index         Text   A   A   A


Using Filters with the Consortia Builder

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.

    Image of a columm header in Excel with the drop-down arrow displayed

    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.

    Image of a columm header in Excel with filtering applied

  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).

For more detailed information about filtering, please refer to Microsoft Excel Help, which is accessible from the Help menu in Excel.

 
  Follow this link to go  Back to top