Sort data in a range or table - Microsoft Support
网页To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting. Check out the video to see how it's done. Windows Web. Sort text. Sort numbers. Sort dates or times. Sort by more than one column or row. Sort by cell color, font color, or icon.
Quick start: Sort data in an Excel worksheet - Microsoft Support
网页When sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data. For example, you can sort employees —first by department, and then by last name.
Add, edit, find, and delete rows by using a data form
网页When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows.
Total the data in an Excel table - Microsoft Support
网页Total the data in an Excel table. Newer Windows versions Newer Mac versions Web. You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.
PERCENTOF function - Microsoft Support
网页Use the PERCENTOF function to return the percentage that a subset makes up of a given data set. It commonly used in GROUPBY and PIVOTBY functions. Note: PERCENTOF is logically equivalent to =SUM (data_subset)/SUM (data_all)
Round a number to the decimal places I want - Microsoft Support
网页Round a number to the number of digits you want by using the ROUND function. This function has only two arguments (arguments are pieces of data the formula needs to run). The first argument is the number you want to round, which can be a cell reference or a number. The second argument is the number of digits you want to round the number to.