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. So you should consider adding it in since a lot of people want it and I don't want to move all my work to my pc and move it back to Mac. On the Data tab, in the Sort & Filter group, choose Sort. Please Add 'Quick Analysis' to Excel for Mac Hi there I see that a lot of people were complaining about not having the quick analysis tool for Mac. Select a single cell anywhere in the range that you want to sort. It won't give you access to Quick Analysis like you've seen on a PC (where you've selected some cells and the icon displays in the lower right-hand corner, or when your cursor is in the middle of a data block and you hit Ctrl q to have Excel auto-select the range it thinks you want to analyze and the QA options pop up for you). 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. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |