im an excel novice

blazeknight · Post by **blazeknight** » Wed Sep 08, 2004 12:38 am

Im an ecel novice, can anyone help me how to sort in excel? I have my entire collection (20,000+++) in word, its a pain
john

DawgPhan · Post by **DawgPhan** » Wed Sep 08, 2004 7:37 am

I belive that under "tools" there is a sort function that will let you sort by any column and what not...look there...

tssgery · Post by **tssgery** » Wed Sep 08, 2004 7:42 am

It's under Data->Sort

Just make sure and select the entire worksheet or it'll just sort one column!

n-boy · Post by **n-boy** » Wed Sep 08, 2004 6:15 pm

tssgery wrote:It's under Data->Sort

Just make sure and select the entire worksheet or it'll just sort one column!

also, remember to check "headers" or "no headers" depending on whether you have headers or not. (i've screwed myself quite a few times on that)

since you're an excel newb, another nice feature is Data -> Filter -> Autofilter. it gives you drop down lists on your headings and allows you to filter by values in each column. (useful when you're looking for just your valiant issues)

HarperDJ · Post by **HarperDJ** » Wed Sep 08, 2004 9:17 pm

I would suggest that you save it as another name like 'Collection 2' then play with it a little. There are many ways that you can sort your spreadhseet and use many types of forms to display what you have. Being that you have so many listed (already, 20k) it will be very dificult for you to do many things and to be able to check yourself before completing a task.

After you save your spreadsheet under the new name then play around with what you have already. Using the steps under Data>Filter>Autofilter will work fine for you, but being that you are new you wil need to play with these features a few times over and over to fully understand what you are doing.

If you don't mind, what are your headings (categories) that you are using. Maybe I can help you and give some advise over the net without actually seeing your sheet.