Quick start: Sort data in an Excel worksheet - Microsoft Support
网页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 …
Sort data using a custom list - Microsoft Support
网页Create or delete a custom list for sorting and filling data. 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.
Sort data (Power Query) - Microsoft Support
网页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).
Sort data in a table - Microsoft Support
网页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:
Filter for unique values or remove duplicate values
网页Filter for unique values or remove duplicate values. In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > …
LOOKUP function - Microsoft Support
网页Syntax. LOOKUP (lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments: lookup_value Required. A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value. lookup_vector Required.
Reapply a filter and sort, or clear a filter - Microsoft Support
网页Filter data in a range or table. Sort data in a range or table. After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.
Video: Sort table contents - Microsoft Support
网页Select a cell in the column you want to sort. Select Sort & Filter and how you'd like to order it: Sort A to Z, Sort Z to A, or Custom Sort. For a Custom Sort: Choose your Sort by, Sort on, and Order sort criteria. To set additional filters, select Add …
Excel calendar templates - Microsoft Support
网页Download a calendar template: Browse through the calendar templates, choose an Excel calendar template that is best for you. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.
Unhide the first column or row in a worksheet - Microsoft Support
网页To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In …
Sort data in a PivotTable or PivotChart - Microsoft Support
网页Sort data in a PivotTable or PivotChart. Sorting data is helpful when you have large amounts of data in a PivotTable or PivotChart. You can sort in alphabetical order, from highest to lowest values, or from lowest to highest values.