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

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 …

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 …

When dates in a worksheet aren't in the order you want, you can sort them. For example, you can sort them from oldest on top to newest on top. Here's how to sort unsorted dates: Drag down …

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 …

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 …

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.