![]() ![]() Click that button in the column you want to filter by, and you’ll get a list of each unique entry in that column. You’ll see a down arrow button appear at the right edge of the top cell in each column of your table. You’ll find the button at the right end of the Home ribbon. ![]() Make sure your cursor (the active cell) is within the list or table of data that you want to filter, then click the Sort & Filter button and choose Filter. You can even do things like show only invoices over a certain dollar amount. ![]() For example, if you have a list of invoices you could use AutoFilter to look at the invoices for just a particular customer, sales rep, or date range. I’ll be using Excel 2010 for this example.ĪutoFilter is a tool that, in essence, lets you hide the rows of a spreadsheet that you don’t want to see. But I decided it was worth revisiting since more than half of my current subscribers weren’t around then and a few versions of Excel have gone by since then. The hours of work that it has saved me made me choose AutoFilter as the Excel tip for my first newsletter almost 6 years ago. One of the most valuable features when analyzing data in Excel is the ability to filter your data in place. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |