
Click on a column heading to change the display order to A-Z/1-9.
Then, click the column heading again to reverse the display order to Z-A/9-1.
A blank value happens when nothing is entered in the field. Move the mouse over the column headings to click on the Filter mini-button. Each column heading has its own Filter mini-button. Then, select Blanks.
A non-blank value occurs when a value has been entered in the field. Move the mouse over the column headings to click on the Filter mini-button. Then, select Non-Blanks.
If you need to create a new filter to produce a specific result, move the mouse over the column headings to click on the Filter mini-button. Select Custom. Now, use the Custom Auto-filter form to set up the custom filter.
After a filter has been applied, use the Filter menu to select All.