Sort data in Excel quickly. When you sort information in an Excel worksheet, you can see data the way you want and find values quickly, in just a few clicks. You can sort a range or table of data on one or more columns of data.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

The SORT function sorts the contents of a range or array. In this example, we're sorting by Region, Sales Rep, and Product individually with =SORT(A2:A17), copied across cells F2, H2, and J2.

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).

You can sort on individual values or on subtotals by right-clicking a cell, clicking Sort, and choosing a sort method. The sort order is applied to all the cells at the same level in the column that contains the cell.

Top of page. Reverse the plotting order of data series in a 3-D chart. You can change the plotting order of data series so that large 3-D data markers do not block smaller ones.

To sort data in ascending or descending order, select Sort A to Z or Sort Z to A. 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).

After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.

Sort text, numbers, dates, or times. Locate a column of text, numbers, dates, or times. Click the arrow in the column header. Do one or more of the following: Sort text. To sort text in ascending order, click Sort Ascending. To sort text in descending order, click Sort Descending. Sort numbers. To sort from low numbers to high numbers, click ...

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, select Data > Sort & Filter > Advanced . To remove duplicate values, select Data > Data Tools > Remove Duplicates .