Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest).Ĭlick to perform a descending sort (from Z to A, or largest number to smallest). Select a single cell in the column you want to sort. The range can include the first row of headings that identify each column. Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). For example, you can sort employees -first by department, and then by last name.
You can sort a range or table of data on one or more columns of data. When sorting information in a worksheet, you can rearrange the data to find values quickly.
0 kommentar(er)
