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

Sort a list by days of the week or months of the year or sort by priorities in Excel. Or you can create your own custom list for items that don't sort well alphabetically.

This means that Excel will dynamically create the appropriate sized array range when you press ENTER. If your supporting data is in an Excel Table, then the array will automatically resize as you …

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a …

Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

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 …

These functions aren't available in earlier versions. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 …

The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array. In this example, we're sorting a list of people's names by their age, in ascending order.