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. On the Data tab, in the Sort & Filter group, choose Sort. Touch device users, explore by touch or with swipe gestures. When autocomplete results are available use up and down arrows to review and enter to select. Moving Office can be a stressful and complicated task. Handy Checklist - Keeps Track of Your Office Move. Ensure a Trouble Free, on-Time, on-Budget Office Move.
Select a single cell anywhere in the range that you want to sort. Download this Office Move Checklist Excel template now How to create an Office Move Checklist in Excel Download this Office Move Checklist Excel template now Pinterest. Moving Office Checklist Free Excel Template Download.
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). Learn how to create a checklist in Excel using the Developer tab and the checkbox form control. 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).