Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. In the Sort dialog box, under Column , in the Sort by or Then by box, select the column that you want to sort by a custom list. In the Custom Lists dialog box, select the list that you want. Using the custom list that you created in the preceding example, click High, Medium, Low.
Note: Tables don't support left to right sorting. Under Row , in the Sort by box, select the row that you want to sort. This will generally be row 1 if you want to sort by your header row. Tip: If your header row is text, but you want to order columns by numbers, you can add a new row above your data range and add numbers according to the order you want them.
Note: When you sort rows that are part of a worksheet outline, Excel sorts the highest-level groups level 1 so that the detail rows or columns stay together, even if the detail rows or columns are hidden. To sort by a part of a value in a column, such as a part number code WDG , last name Carol Philips , or first name Philips, Carol , you first need to split the column into two or more columns so that the value you want to sort by is in its own column.
To do this, you can use text functions to separate the parts of the cells or you can use the Convert Text to Columns Wizard. For examples and more information, see Split text into different cells and Split text among columns by using functions.
Warning: It is possible to sort a range within a range, but it is not recommended, because the result disassociates the sorted range from its original data. If you were to sort the following data as shown, the selected employees would be associated with different departments than they were before.
If you did not intend to sort like this, then press the Expand the selection option, otherwise select Continue with the current selection. If the results are not what you want, click Undo. Check to see if the values returned by a formula have changed If the data that you have sorted contains one or more formulas, the return values of those formulas might change when the worksheet is recalculated.
In this case, make sure that you reapply the sort to get up-to-date results. Unhide rows and columns before you sort Hidden columns are not moved when you sort columns, and hidden rows are not moved when you sort rows. Before you sort data, it's a good idea to unhide the hidden columns and rows. Check the locale setting Sort orders vary by locale setting. Make sure that you have the proper locale setting in Regional Settings or Regional and Language Options in Control Panel on your computer. For information about changing the locale setting, see the Windows help system.
Enter column headings in only one row If you need multiple line labels, wrap the text within the cell. Turn on or off the heading row It's usually best to have a heading row when you sort a column to make it easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation. Occasionally, you may need to turn the heading on or off so that the value in the heading is or is not included in the sort operation.
Do one of the following:. If your data is formatted as an Excel table, then you can quickly sort and filter it with the filter buttons in the header row. If your data isn't already in a table, then format it as a table. This will automatically add a filter button at the top of each table column. Click the filter button at the top of the column you want to sort on, and pick the sort order you want.
If your data has a header row, pick the one you want to sort on, such as Population. Sort Ascending to sort A to Z, smallest to largest, or earliest to latest date. Sort Descending to sort Z to A, largest to smallest, or latest to earliest date. Let's say you have a table with a Department column and an Employee column. You can first sort by Department to group all the employees in the same department together, and then sort by name to put the names in alphabetical order within each department.
In the Custom Sort dialog box, under Column , in the Sort by box, select the first column that you want to sort. Note: The Sort On menu is disabled because it's not yet supported.
For now, you can change it in the Excel desktop app. To add another column to sort by, click Add and then repeat steps five and six. To change the order in which the columns are sorted, select an entry and then click the Up or Down arrow next to the Options button. Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors. In the Sort by dropdown list, select the first column on which you want to sort. In the Order list, choose the order that you want to apply to the sort operation—alphabetically or numerically, ascending or descending that is, from A to Z or Z to A for text, or lower to higher, or higher to lower for numbers.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort. Sort A to Z - sorts the selected column in an ascending order. Sort Z to A - sorts the selected column in a descending order.
Custom Sort - sorts data in multiple columns by applying different sort criteria. Select Add Level. For Column , select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. For example, Sort by Department and Then by Status.
Note: To delete a level, select Delete Level.
0コメント