Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show. By: Jess Stratton course • 2h 11m 42s • 4,833 viewers • Course Transcript - Most sorting operations arranged data into numerical or alphabetical order, but what do you do if your data doesn't make sense if it's sorted into alphabetical order? Well, in that case, you can create a custom order. This workbook contains two data lists that are both organized in alphabetical order for one column, but it doesn't make sense. On the left, you can see that I have the months for the year 2014 arranged in alphabetical order, which, of course, is not the correct order for where they fall in the year and the same thing for the seasons over in the right section. For example, if you want to re-sort the previous example by delivery date, under Sort by, choose delivery. Under Order, select Custom List. In the Custom Lists box, select the list you want, and then click OK to sort the worksheet. Best mp3 download for mac. I have Fall, Spring, Summer, and Winter when, in fact, those are not in the proper order, so how do I sort using a custom list? Well, it depends on whether the custom list is built-in or whether it's one you have to make yourself. Months are, in fact, a custom list that comes with Excel, so you can just make the appropriate selections when you perform your sort. So I'll click cell B2. Actually, it's already selected, but you can click any cell in the B column in the left-hand data list, and then on the Home tab click the Sort & Filter button and click Custom Sort. In here, you can see that I have a sort level, and I'm sorting by month, which is correct, but I'm sorting on values, which is correct, A to Z, which is not. That's what gave me this nonsensical alphabetical order in the first place, so I need to click the Order list arrow and from the three items that appear, I click Custom List. Doing so displays the custom lists that are built-in to Excel or that you have added yourself. So you see here we have Sunday, Monday, Tuesday in both short and long formats, the short format for the months and the long formats for the months. So what I want to do is to click this bottom list, January, February, March, and so on, and click Ok to use that as my sorting criteria, and now when I click OK, you see that my list has been sorted into the appropriate order, so that's what you do if you're using one of the four lists that are built-in. If you want to create your own, then you need to open the Excel Preferences dialog box. To do that, hold down the Command key and type a comma. That displays the Excel Preferences dialog box. You can also display that by opening the Excel menu and clicking Preferences. ![]() But from here, look in the middle section and click Custom Lists. The Custom Lists dialog box let's you either use an existing list or create a new one, so I'll click new list and then click over in the List entries box. I want to put the seasons into the proper chronological order, so I'll type Spring, then return, Summer, return, Fall, return, Winter, and then click Add. Doing so displays the list. You see it has Spring, Summer, Fall, and Winter. If I want to delete a list after I've created it, then I can just click it and click Delete. If your values are already available in your worksheet, then you can display the Custom Lists page of the Excel Preferences dialog box. Then click in the Import list from cells box, click the collapse dialog button, select the cells, and then click Import, but in this case I'm done, so I can close the Excel Preferences dialog box. Now I'll go to my data list on the right, and I'll click any cell in the Season column. Then again on the Home tab click the Sort & Filter button. Click Custom Sort, so I'm sorting by, and my column will be Season. I am sorting by values, but instead of A to Z, I'll click the list arrow and get a Custom List, and I'll click Spring, Summer, Fall, and Winter, which is at the bottom. Everything looks good.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |