How to Check the Purchase History of Marie
Step 1: Click on the Drop Down of Customer Name
Click on the arrow near the Customer name
Step 2: Click on Select All Option
Click on the Select All option.
Step 3: Check on Customer Name “Marie”
The filter is applied to the column which shows the purchase details of Marie.
How to Add, Use and Remove Filter in Excel
Working with a database is a crucial job. With every data added increases the comprehensiveness to manage records and pick out the needed information from any corner of the database. Keeping the struggle in mind, Excel is a great tool to store and extract data in a hassle-free manner.
The filter option provides efficiency in searching for the needed data from a huge pile of records. Let’s understand what exactly the filter option is. The filter in Excel displays data that is relevant for the users to make decisions. The user applies some criteria and the records get separated wherein required data show up and others disappear.
Contact Us