![]() ![]() On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window. Select a single cell anywhere in the range that you want to sort. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |