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

C

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
 
F

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
 
T

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.
 
C

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
 
C

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
 
C

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
 
B

Bob I

See "filter"

Chris said:
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


:
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top