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

Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest). Click to perform a descending sort (from Z to A, or largest number to smallest). Sort by specifying criteria.

Use the SORT and SORTBY functions to automatically sort your data. Also, see Filter data in an Excel table or range, and Apply conditional formatting in Excel. How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

Tables. Sort data in a table. Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort. Sort the table. Select a cell within the data. Select Home > Sort & Filter. Or, select Data > Sort. Select an option:

Windows 11 Windows 10. Find your Windows settings in a snap! Select the Start button, then select Settings . From there, browse the categories or use search to find what you're looking for. Windows 11 Windows 10. Tips: Most apps have their own settings. In the app, select Settings to make app-specific changes.

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.

To reapply a filter or sort, on the Home tab, in the Editing group, click Sort & Filter, and then click Reapply. Top of Page. Clear a filter for a column. To clear a filter for one column in a multicolumn range of cells or table, click the Filter button on the heading, and then click Clear Filter from <Column Name>.

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 Sort Ascending. To sort from high numbers to low numbers, click Sort Descending.

If the steps above don't work, you may need to reinstall Windows. For more info, see Windows 10 recovery options. Describes how to use the System File Checker tool to troubleshoot missing or corrupted system files in Windows 8.1, Windows 8, Windows 7 or Windows Vista.

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. Syntax. Examples. Sort a table by Region in ascending order, then by each person's age, in descending order.