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

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

You can sort on individual values or on subtotals by right-clicking a cell, choosing Sort, and then choosing a sort method. The sort order applies to all the cells at the same level in the column …

In Excel for Mac, you can sort a list of data by days of the week or months of the year. Or, create your own custom list for items that don't sort well alphabetically. You can also sort by font …

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

To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, …

Select one or more cells in a range, table, or PivotTable report. Enter the values that you want to use and then choose a format. To change a conditional format, begin by ensuring that the …

When you remove duplicate values, only the values in the selected range of cells or table are affected. Any other values outside the range of cells or table are not altered or moved.

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 …

If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT …