If you have a lengthy list in Excel and sort it to find records (rows), you can instead use a Filter to omit any records (rows) that don’t meet your requirements. It’s easy and you won’t lose any data. If you want to only print specific data, filtering the data will only print the data you select. An easy and quick way to only display the information that you need at the time. It can easily be reverted back to display the original list with just the click of a button.
For step-by-step instructions on how to filter a list in Excel, visit http://helpdesk.etown.edu/help/filter_a_list.