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.

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.

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

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). The # sign is called the spilled range operator. Use SORTBY to sort a table of temperature and rainfall values by high temperature. Error conditions

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.

How to use the FILTER function in Excel to filter a range of data based on criteria you define.

Sorting data helps you understand your data better, organize, and find the data that you want, and ultimately make decisions that are more effective. What do you want to do? Sort text, numbers, dates, or times

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

Learn how to highlight, sort, and filter, your tables (or data in another supported format) with Copilot in Excel.

Use the AutoFilter to filter a range of data in Excel 2010 and learn how to remove filters.