June 20, 2013

Filter Tool in Microsoft Excel 2010

The Filter Tool in Excel is very helpful when you are sorting through a lot of data.  You are quickly able to view only the data that you need.  First click the Data tab and in the Sort & Filter group, then click Filter.  Now a drop down arrow will appear next to each column on your first row. Click the arrow where you can select exactly what data you would like filtered out.  For example, let’s say you have a list of names and addresses that you send out newsletters to.  But, for this specific mail out you only want to mail to people within a certain city.  Rather than having to scroll through all of your data, you can simply Filter your list by the Column designated for cities.

No comments:

Post a Comment