In the Order list, select the order that you want to apply to the sort operation - alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).įor more information about how to sort data, see Sort data in a range or table . ![]() In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. In the Sort by list, select the first column on which you want to sort. When people refer to Excel files, they are referring to workbooks, which are files that contain one or more sheets of data on. On the Data tab, in the Sort & Filter group, choose Sort. To resume at a later time, run Excel, open the file called. Select a single cell anywhere in the range that you want to sort. Break Point: If you wish to take a break, this is a good place to do so. ![]() Select a single cell in the column on which you want to sort.Ĭlick to perform an ascending sort (A to Z or smallest number to largest).Ĭlick to perform a descending sort (Z to A or largest number to smallest). ![]() The range can include titles that you created to identify columns or rows. A modern take on Excel with new built-in tools help. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). Image result for Microsoft Excel Excel for insightful spreadsheets anytime, anywhere and with anyone.
0 Comments
Leave a Reply. |