![]() Excel-erate your productivity with the only guide youll need to the latest versions of Microsoft Excel. 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 . 15.00 - 26.49 22 Used from 15.00 22 New from 24.78. In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon. ![]() Mouse and keyboard equivalent: Hold down the control key on the keyboard while using the mouse wheel to grow or shrink an item on the screen. The onscreen image expands or shrinks accordingly. This step-by-step guide is packed with exercises that walk you through the basic. In the Sort by list, select the first column on which you want to sort. Pinch or stretch: Place two fingers on the screen and then move them as if you were pinching or stretching a sheet of paper. Excel Workbook For Dummies is the hands-on tutorial youve been waiting for. ![]() This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. On the Data tab, in the Sort & Filter group, choose Sort. Excel Workbook For Dummies is the hands-on tutorial youve been waiting for. 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). Reviews arent verified, but Google checks for and removes fake content when its identified. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |