AutoFilter
āĻ¸ā§āĻŦā§āĻāĻā§āĻ°āĻŋā§āĻāĻžāĻŦā§ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻāĻŋāĻ¤ āĻāĻ° āĻĒāĻ°āĻŋāĻ¸āĻ° āĻĒāĻ°āĻŋāĻļā§āĻ§āĻ¨ āĻāĻ°ā§, āĻāĻŦāĻ āĻāĻ°-āĻ¸āĻžāĻ°āĻŋ āĻŦāĻžāĻā§āĻ¸ āĻ¤ā§āĻ°āĻŋ āĻāĻ°ā§ āĻ¯ā§āĻāĻžāĻ¨ā§ āĻāĻĒāĻ¨āĻžāĻ° āĻĒā§āĻ°āĻĻāĻ°ā§āĻļāĻ¨ āĻāĻ°āĻ¤ā§ āĻāĻžāĻāĻ¯āĻŧāĻž āĻāĻĒāĻžāĻĻāĻžāĻ¨ āĻāĻĒāĻ¨āĻŋ āĻĒāĻāĻ¨ā§āĻĻ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨āĨ¤
āĻāĻŋāĻ¨ā§āĻ¨ā§āĻ¯ āĻĒāĻžāĻ¤āĻžāĻ¯āĻŧ āĻāĻŋāĻ¨ā§āĻ¨ā§āĻ¯ AutoFilters āĻŦāĻ°āĻžāĻĻā§āĻĻ āĻāĻ°āĻ¤ā§, āĻāĻĒāĻ¨āĻžāĻā§ āĻ āĻŦāĻļā§āĻ¯āĻ āĻĒā§āĻ°āĻĨāĻŽā§ āĻĒā§āĻ°āĻ¤āĻŋ āĻĒāĻžāĻ¤āĻžāĻ¯āĻŧ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻĒāĻ°āĻŋāĻ¸āĻ° āĻ¸āĻāĻā§āĻāĻžāĻ¯āĻŧāĻŋāĻ¤ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤
Sort Ascending
Displays the rows of the cell range in ascending order, based on the values in the cells of the current column.
Sort Descending
Displays the rows of the cell range in descending order, based on the values in the cells of the current column.
Filter by Color
Text color
Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected.
Background color
Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected.
Filter by Condition
Empty
Displays only the rows of the cell range that have an empty cell in the current column.
Not Empty
Displays only the rows of the cell range that have a non-empty cell in the current column.
Top 10
Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.
Bottom 10
Displays the 10 rows of the cell range that contain the lowest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.
Standard Filter
Opens the Standard Filter dialog.
Search text box
Search for a specific entry in the list of values found in the current column. As characters are typed in the text box, this list is updated to show only matching entries.
All
Click once to select to show all rows and click again to select to hide all rows.
Show only current item
Display only rows containing the value highlighted in the Value box.
Hide only current item
Hide all rows containing the value highlighted in the Value box and display all other rows.
Values
List of unique values found in the current column.