Your worksheet may contain long columns of information, but you may want to view only a certain part of the column at one time. Using the AutoFilter tool in Excel allows you to easily sort a column of information and only display the parts you want or need.
To filter a column using Autofilter:
|
|
Excel creates a list of filters based on the first 1000 unique entries. You can also filter columns by number and text. To show all entries in a column, select (All). |