Use filter in Excel (ZT)

When you're looking at very large data sets, you don't usually need to be looking at every single row at the same time. Sometimes, you only want to look at data that fit into certain criteria. That's where filters come in.

Filters allow you to pare down your data to only look at certain rows at one time. In Excel, a filter can be added to each column in your data -- and from there, you can then choose which cells you want to view at once.

Let's take a look at the example below. Add a filter by clicking the Home tab and selecting "Filter." Clicking the arrow next to the column headers and you'll be able to choose whether you want your data to be organizing in ascending or descending order, as well as which specific rows you want to show.