What is the use of filter drop down button in Excel?
In detail..
Answers
Answer:
You can quickly filter the data in a report by selecting one or more values in a report and using the Filter drop-down button.
Explanation:
Example
You have a report that lists Customer Name, Order Date and Total Sales. You click the Filter drop-down button and select Between to filter the report so that it shows only the sales that took place within the last six months.
Steps
Select one or more values in a column.
Click the Filter drop-down button. A drop-down menu appears.
Select a filter operator from the drop-down menu.
To filter on the selected values, click In.
To filter out the selected values, click Not In.
To filter the selection on a given range, click Between.
To filter out the selection on a given range, click Not Between.
To filter the selection based on one or more values, click an operator such as =, <, < , <=, , =.
Note: The contents of the Filter drop-down menu vary depending on the selection you made in step 1.
Position the cursor over the arrow that appears at the right of the drop-down menu. A fly-out menu appears.
From the fly-out menu that lists available options, do one of the following:
To filter a report on one or more data items currently highlighted, click Selection.
To enter one or more numbers upon which to filter, click Number.
To select from a list of values upon which to filter, click Select Values.
To enter one or more text strings upon which to filter, click String.
To enter one or more dates upon which to filter, click Date.
To enter one or more times upon which to filter, click Time.
To enter a date and time variable upon which to filter, click Date-time.
To enter one or more intervals upon which to filter, click Interval.
Note: The contents of the Filter fly-out menu vary depending on the selection you made in step 1.
If you chose
Selection, the filter is automatically applied to the report
Select Values, the Select Values dialog box appears, where you can choose from all the values for the selected data item
any of the other options, the Enter Values dialog box appears, where you can enter or select the required value or values and click OK
Explanation:
This is your answer...
Hope this may help you...
