How do I create filters to sort ALIS reports in Excel? Updated on 05.05.2015 Reports, Resident Reports For: Administrators Choose the column you would like to filter and select the appropriate cell Click the “Data” menu option Select “Filter” Drop-down menus will appear next to each cell heading Click on the arrow to show the drop down menu Filter your spreadsheet by selecting or deselecting the appropriate values