You then select a specific value from one of the drop-down lists to display all records in your list containing that value. Using AutoFilterĬhoosing AutoFilter from the Sort and Filter group on the Home tab applies drop-down arrows directly to column labels in your list, as illustrated in Figure 1-13. You can then copy this filtered list to another location without disturbing the primary source list. The remaining records are hidden from view until you instruct Excel to display them again. What if you suddenly needed to know how many types of cheese were on the shelf? You could scroll through the entire list, counting the cheeses as you go, but it would make more sense to filter the list so that it displays only dairy products, or better yet, only cheeses.įiltering a list lets you find and work with a subset of the data in your list by displaying only the records that contain a certain value or meet specific criteria. ![]() ![]() Your list would include everything from dairy products to fresh vegetables to cookies. For example, suppose you operate a small grocery store and have a master inventory of all the items in the store. Filtering can give you more control over your list, particularly if your list contains a large number of records.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |