With built-in custom lists, you can sort by days of the week or months of the year. If you want to sort your data in some custom order other than alphabetical, you can use the built-in Excel custom lists or create your own. Sort data in custom order (using a custom list) But what if we have data that does not sort well alphabetically or numerically? Hope now you've gained an insight into how sorting a row works in Excel. In other words, what you see in the screenshot above is the list of photo cameras sorted from cheapest to most expensive. The entire columns were moved so that the data was not distorted. Please note that it's not just one row that has been sorted. The result of sorting will look like this: What you do is go through steps 1 - 3 as described above and then, on step 4, instead of Row 2 you select Row 4 that lists retail prices. For instance, let's sort them by price for a start. In a similar way, you can sort the list of cameras by size, or imaging sensor, or sensor type, or any other feature that is most critical for you. I know that sorting by column names has very little practical sense in our case and we did it for demonstration purposes only so that you can get a feel of how it works. The result of your sorting should look similar to this: Make sure you have " Values" selected under Sort on and " A to Z" under Order, then click OK. In our example, we select Row 1 that contains the photo camera names. Then select the row by which you want to sort.In the opening Sort Options dialog under Orientation, choose Sort left to right, and click OK.Since our sheet has headers, we leave the tick and click the Options button. Notice the " My data has headers" checkbox in the upper-right part of the dialog, you should uncheck it if your worksheet does not have headers. Click the Sort button on the Data tab to open the Sort dialog.We cannot do this for our data because Column A lists different features and we want it to stick in place. If you want to re-arrange all the columns, you can simply select any cell within your range. Select the range of data you want to sort.As an example, let's sort them by model name first. What you need is to sort the photo cameras by some parameters that matter the most for you. The list contains different features, specifications and prices like this: rearrange the order of columns from left to right based on column headers or values in a particular row.įor example, you have a list of photo cameras provided by a local seller or downloaded from the Internet. However, sometimes we have non-trivial data sets and we do need to sort by row (horizontally), i.e. I guess in 90% of cases when you are sorting data in Excel, you sort by values in one or several columns.
#Sng tool to sort active tables how to
If values you wish to sort include text and numeric characters, check out How to sort mixed numbers and text in Excel. Also, you will learn how to sort your Excel data in non-standard ways, when sorting in alphabetical or numerical order does not work. Further on in this article I will show you how to sort by row, not column, and how to re-arrange data in your worksheet alphabetically based on column names. Sorting data by multiple columns in Excel is pretty easy, isn't it? However, the Sort dialog has plenty more features.
You want to sort them first by Region, then by Board basis and finally by Price, as shown in the screenshot: For example, you are planning your holiday and have a list of hotels provided by a travel agency. From the " Sort by" and " Then by" dropdown lists, select the columns by which you want to sort your data.Then click the Add Level button as many times as many columns you want to use for sorting:.Click the Sort button on the Data tab or Custom Sort on the Home tab to open the Sort dialog.You may only notice some differences in color schemes and dialogs' layouts. If you use another Excel version, you won't have any problems with following the examples because the sorting features are pretty much the same in Excel 2007 and Excel 2013. I will do this in Excel 2010 because I have this version installed on my computer. Now I'm going to show you how to sort Excel data by two or more columns.
0 kommentar(er)
