Maybe you're thinking of the auto filter function?
Just highlight your column headings, click "data", scroll over "filter", then a mini menu pops up to the left, click "AutoFilter".
In Excel 2007 it works similarily, exept under the data tab there is an icon that looks like a funnel, click that.
|