Sort Excel items into a sequence that is neither AZ or ZA.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth 20 - Custom Sorting!
Hey, welcome back to the MrExcel netcast, I’m Bill Jelen.
I love this trick, I used to run into this one all the time, I have three regions of this country: Central, East, and West, and I want East to sort first.
So you see, if I come here and do Data, A-Z, Central comes first, Z-A, West comes first, there's no way to hit East to come first.
And, you know, this is just a hassle, you have this all the time, you have product lists or product lines, or, you know, whatever, you need to sort it into some special sequence.
So, come out here, just to a blank section spreadsheet, and we're going to teach Excel how to sort East-Central-West is how I want this to appear.
Type those, choose those cells, we go to Excel Options, right down here, Excel Options.
It used to be right here in the first screen in Excel 2007, now it's hidden back here.
Advanced, scroll down, “Edit Custom Lists”, alright, and we're going to import our list.
So there's where I typed East-Central-West, click import, East-Central-West, you also could, by the way, type it here, but for me it's easier to type it in the cells.
Make sure I get it right, click OK.
Alright, now Excel understands that custom list, and it's now available to us when we sort using this sort dialog.
Alright, so I'm not going to sort with these two buttons, I want to come into sort, say “I want to Sort by Region, Sort On Values”, but instead of A-Z or Z-A, ahahaha, Custom List!
And I wanted to sort it in the East-Central-West sequence, click OK, click OK.
So then East comes first, followed by Central, followed by West.
Alright, very easy to set up a custom list, once you set up a custom list, it works on every workbook on the computer.
Something would change, you get a new region, go back and edit the custom list, allows you to do all kinds of cool things as sorting, of course.
And then also, you know, the other thing you can do, is take the first item from the list, grab the fill handle and drag, and it will type the remaining items from the list.
So that's the other benefit of custom list, but the big one here, in this chapter talking about sorting, is being able to sort by custom lists.
Well hey, I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
Excel In Depth 20 - Custom Sorting!
Hey, welcome back to the MrExcel netcast, I’m Bill Jelen.
I love this trick, I used to run into this one all the time, I have three regions of this country: Central, East, and West, and I want East to sort first.
So you see, if I come here and do Data, A-Z, Central comes first, Z-A, West comes first, there's no way to hit East to come first.
And, you know, this is just a hassle, you have this all the time, you have product lists or product lines, or, you know, whatever, you need to sort it into some special sequence.
So, come out here, just to a blank section spreadsheet, and we're going to teach Excel how to sort East-Central-West is how I want this to appear.
Type those, choose those cells, we go to Excel Options, right down here, Excel Options.
It used to be right here in the first screen in Excel 2007, now it's hidden back here.
Advanced, scroll down, “Edit Custom Lists”, alright, and we're going to import our list.
So there's where I typed East-Central-West, click import, East-Central-West, you also could, by the way, type it here, but for me it's easier to type it in the cells.
Make sure I get it right, click OK.
Alright, now Excel understands that custom list, and it's now available to us when we sort using this sort dialog.
Alright, so I'm not going to sort with these two buttons, I want to come into sort, say “I want to Sort by Region, Sort On Values”, but instead of A-Z or Z-A, ahahaha, Custom List!
And I wanted to sort it in the East-Central-West sequence, click OK, click OK.
So then East comes first, followed by Central, followed by West.
Alright, very easy to set up a custom list, once you set up a custom list, it works on every workbook on the computer.
Something would change, you get a new region, go back and edit the custom list, allows you to do all kinds of cool things as sorting, of course.
And then also, you know, the other thing you can do, is take the first item from the list, grab the fill handle and drag, and it will type the remaining items from the list.
So that's the other benefit of custom list, but the big one here, in this chapter talking about sorting, is being able to sort by custom lists.
Well hey, I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
