Auto filter

Highlight an entire header row or a particular heading of a column. Go to data, filter and autofilter. This turns it on. You will be able to click on the little arrow and you will see a list of all unique values in the column. If for example you have the value of 'France' in that column several times (say you are looking at a sales data sheet and want to only return the french sales) then choosing france from the filter list would show only records with France value. Its basically a simple way to show groups of records together. If there is a filter on the column, the arrow will turn blue. You can use more than one filter on the data, for example to show all frenhc sales for a particular month.