Need really fast method to sort data for my part numbering spread

[Chris Dundorf]

I have a part numbering spreadsheet for my manufacturing business. Columns
are: 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

 

[Fred Smith]

What happened when you tried it?

Sort will remember the parameters you give it, so after you've done it the
first time, you should be able to repeat it with one or two clicks.

If you need further help, post back with the version of Excel you are using.

Regards,
Fred

 

[trip_to_tokyo]

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]

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

 

[Chris Dundorf]

trip_to_tokyo,

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

Thanks,
Chris

 

[Chris Dundorf]

Hi Fred,

I'm running Office 2007. I just replied to "trip-to_tokyo" saying that his
example spread sheet has the drop-down sorting tool that I'm looking (2
clicks to sort any column...) for but that I don't know how he created the
tool so that they stay near the top of the column.

My data sorting doesn't appear to remember what I did., in that I need to go
up to the Data tab > Sort > then select the cells to sort and type of sorting
to perform.

Chris

 

[Bob I]

See "filter"

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


:

 

[Fred Smith]

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 Data>Filter.

If your data has blanks in it, highlight the entire table, then use
Data>Filter.

Regards,
Fred