On the Data tab, in the Sort & Filter group, do one of the following: To quick sort in ascending order, select (Sort A to Z). To quick sort in descending order, select (Sort Z to A).

Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest). Click to perform a descending sort (from Z to A, or largest number to smallest).

Sort a range of values in descending order. Use SORT and FILTER together to sort a range in ascending order, and limit it to values over 5,000. Need more help?

In the Select Data Source dialog box, in the Legend Entries (Series) box, select the data series that you want to change the order of. Select the Move Up or Move Down arrows to move the data series to the position that you want.

You can sort data to arrange in: Ascending order (text is A-Z, number is smallest to largest, and date is oldest to newest). Descending order (text is Z-A, number is highest to lowest, and date is newest to oldest).

To sort data in ascending or descending order, select Sort Ascending or Sort Descending. Text entries will sort in alphabetical order, numbers will sort from smallest to largest (or vice versa), and dates or times will sort from oldest to newest (or vice versa).

To sort specific items manually or change the sort order, you can set your own sort options. Click a field in the row or column you want to sort. Click the arrow next to Row Labels or Column Labels. Under Sort, choose Ascending or Descending, and select from the options in the Sort by list. (These options will vary based on the your selections ...

To sort text in descending order, click Sort Descending. Sort numbers. To sort from low numbers to high numbers, click Sort Ascending. To sort from high numbers to low numbers, click Sort Descending. Sort dates or times. To sort from an earlier to a later date or time, click Sort Ascending. To sort from a later to an earlier date or time, click ...

With built-in custom lists, you can sort data—either by days of the week or months of the year. Optionally, you can create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically—such as high, medium, and low—or S, M, L, XL.

Sort a table by Region in ascending order, then by each person's age, in descending order. Use SORTBY with RANDARRAY , and COUNTA to randomize a list of values. In this case, E2# references the dynamic array range beginning in cell E2, as that was populated by using = SEQUENCE (10).