正文

Use filter in Excel (ZT)

(2017-03-18 14:00:45) 下一个

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.

[ 打印 ]
阅读 ()评论 (0)
评论
目前还没有任何评论
登录后才可评论.