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 …

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, …

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# …

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 …

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 …

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 …

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.

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 …

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 …