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. Excel Workbook For Dummies, 2nd Edition Paul McFedries, Greg Harvey E-Book 978-7-1 December 2021 18.00 Paperback 978-5-7 January 2022 29. On the Data tab, in the Sort & Filter group, choose Sort. Excel 2022: The most updated bible to master Microsoft Excel from scratch in less than 7 minutes a day Discover all the features & formulas with step-by-step tutorials Leonard J. ![]() Select a single cell anywhere in the range that you want to sort. 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 |