Filtering Reports on Excel

Sorting the report generated by a specific column.

This is helpful if you would like to order your report by a specific column on your report. 

Example: Sorting an emergency contact list by room type.

1. On the sheet, highlight column you want to sort by clicking the corresponding letter above (this will select the entire column in one click.)

Screen_Shot_2018-05-18_at_11.54.48_am.png

2. In the top panel, click the Filter Icon.

Screen_Shot_2018-05-18_at_11.53.41_am.png

The filter icon is located in the far right of the top panel. 

Screen_Shot_2018-05-18_at_11.56.28_am.png

3. Select filter "A to Z" from drop down list, which will signify to sort the column you have previously selected in alphabetical order.

4. This will automatically sort the information on the sheet, according to those rooms. 

5. You may then delete any information you no longer need off the sheet if needed and print the newly refined document.