WEBVTT Kind: captions Language: en 00:00:10.240 --> 00:00:12.070 When you have a lot of different rows in your spreadsheet, 00:00:12.070 --> 00:00:17.020 you may want to sort the data so that you can view it more easily. 00:00:17.020 --> 00:00:23.789 Sorting can re-order things alphabetically, numerically, by date, or even by font color. 00:00:23.789 --> 00:00:26.160 Depending on your preference, you can either sort 00:00:26.160 --> 00:00:29.000 in the Home tab from the Sort & Filter drop-down 00:00:29.000 --> 00:00:32.730 menu, or you can use the commands in the Data tab, 00:00:32.730 --> 00:00:34.120 and these are the ones I'm going to be using. 00:00:34.120 --> 00:00:42.011 In this example, I have a t-shirt order form, and 00:00:42.011 --> 00:00:44.320 I'd like to sort it by Last Name. 00:00:44.320 --> 00:00:47.180 Just select any cell in the column that you want 00:00:47.180 --> 00:00:48.670 to sort, 00:00:48.670 --> 00:00:57.390 and then click the Ascending command - it's the one that says A-Z. 00:00:57.390 --> 00:00:59.040 You'll notice that when you sort the column, it 00:00:59.040 --> 00:01:00.370 also reorders all of the 00:01:00.370 --> 00:01:06.360 other columns, so that each row still has the correct information. 00:01:06.360 --> 00:01:12.060 If we wanted these in reverse order, we could click the Descending command. 00:01:12.060 --> 00:01:14.820 We could also sort it by Homeroom, which sorts it 00:01:14.820 --> 00:01:23.539 numerically, or we could sort it by Date. 00:01:23.539 --> 00:01:28.030 Now what if we wanted to sort this by T-Shirt Size? 00:01:28.030 --> 00:01:30.160 If I click on the Ascending command, the 00:01:30.160 --> 00:01:37.439 order will be Large, Medium, Small, X-Large because it's ordering them alphabetically. 00:01:37.439 --> 00:01:41.609 It would be better if it went Small, Medium, Large, X-Large, 00:01:41.609 --> 00:01:45.179 and for this we'll need to create a custom sort. 00:01:45.179 --> 00:01:51.149 Click the Sort command, and this opens a dialog box. 00:01:51.149 --> 00:01:56.710 And on the right, you can see that it's ordering from A to Z. 00:01:56.710 --> 00:02:00.299 If you click on that and select Custom List, you'll be able to 00:02:00.299 --> 00:02:04.380 type in the T-Shirt sizes in the order that you want. 00:02:04.380 --> 00:02:10.880 So I'll type Small, Medium, Large, and X-Large. 00:02:10.880 --> 00:02:13.490 And I'm pressing Enter after each one, and then 00:02:13.490 --> 00:02:16.190 click Add. 00:02:16.190 --> 00:02:18.780 Make sure that your list is selected over here, 00:02:18.780 --> 00:02:23.930 and then click OK. 00:02:23.930 --> 00:02:28.700 And now, it's ordered the way that we want. 00:02:28.700 --> 00:02:31.330 The only problem with this is every other column 00:02:31.330 --> 00:02:33.450 is completely out of order now. 00:02:33.450 --> 00:02:35.710 What I would really like is if the Homerooms were 00:02:35.710 --> 00:02:38.220 more organized within each size. 00:02:38.220 --> 00:02:41.320 I can do this by sorting multiple levels. 00:02:41.320 --> 00:02:44.000 This will let us sort first by T-Shirt size, and 00:02:44.000 --> 00:02:48.060 then by Homeroom. 00:02:48.060 --> 00:02:51.080 Click the Sort command. 00:02:51.080 --> 00:02:57.400 And we want to Add a Level. 00:02:57.400 --> 00:03:00.290 Then just select Homeroom, and then we'll leave 00:03:00.290 --> 00:03:03.260 these the way they are. 00:03:03.260 --> 00:03:05.200 When you click OK, you'll see that within each 00:03:05.200 --> 00:03:06.480 T-Shirt size, 00:03:06.480 --> 00:03:11.660 the Homerooms are in numerical order. 00:03:11.660 --> 00:03:14.200 If we wanted to sort by Homeroom first and then by 00:03:14.200 --> 00:03:16.960 T-Shirt size, we could go back to the Sort 00:03:16.960 --> 00:03:23.360 command, and then select one of these rows, and 00:03:23.360 --> 00:03:26.510 then use these arrows to change the order. 00:03:26.510 --> 00:03:36.680 As you can see, there are a lot of different ways 00:03:36.680 --> 00:03:38.200 of sorting your data, 00:03:38.200 --> 00:03:40.210 depending on how you want to organize it. 00:03:40.210 --> 00:03:44.670 So take some time to experiment with the different options to find the ones that best suit your 00:03:44.670 --> 00:04:06.530 needs.