It's a Data Filter.

If your data is well managed (doesn't have any blank rows or columns),
highlight the top row, then use DataFilter.

If your data has blanks in it, highlight the entire table, then use
DataFilter.

Regards,
Fred

"Chris Dundorf" wrote in message
...
trip_to_tokyo,

What you created is exactly what I'm looking for. Please tell me how to
make the drop-down soting tools appear near the top of each column.

Thanks,
Chris


"trip_to_tokyo" wrote:

Hi Chris.

I have just put up an EXCEL 2007 file for you at:-

http://www.pierrefondes.com/

- item number 75 towards the top of my home page.

All you have to do is to click the filter buttons in the top row to get
what
you want.

If my comments have helped please hit Yes.

Thanks.



"Chris Dundorf" wrote:

I have a part numbering spreadsheet for my manufacturing business.
Columns
a Part #, Description, Mfg P/N, Mfg Name, Cost, weblink, etc. There
is
one header row with above descriptions. I typically need to sort by
Part #
or Description. Is there are really quick way to run the sort
function. I
love it to be one or two mindless clicks.
Thanks,
Chris