In the Order list, choose the order that you want to apply to the sort operation-alphabetically or numerically, ascending or descending (that is, from A to Z (or Z to A) for text, or lower to higher, or higher to lower for numbers). In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon. In the Sort by dropdown list, select the first column on which you want to sort. On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window. Select a single cell anywhere in the range that you want to sort. Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest).Ĭlick to perform a descending sort (from Z to A, or largest number to smallest). Select a single cell in the column you want to sort. The range can include the first row of headings that identify each column. Why does Powerpoint for Mac not have this shortcut I cannot think of a reason why it wouldn't be present other than simply being overlooked, as the format painter functionality is there in the app and other other Office. Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). Outlook / Word / Excel for Mac all have the same keyboard shortcut for copy and pasting format (Cmd+Shift+C and Cmd+Shift+V).

For example, you can sort employees -first by department, and then by last name. You can sort a range or table of data on one or more columns of data. When sorting information in a worksheet, you can rearrange the data to find values quickly.

Excel shortcut for format painter mac