Or click the ZA button to sort in the opposite order, so larger numbers and words later in the alphabet come first. Generally Excel will detect if there are headers present and leave those rows ...

The formula =SORT(A3:B17) uses the default “sort by” and “sort order” settings; thus, the list is sorted in alphabetical order. The syntax for the new SORT function is =SORT(array, [sort_index], [sort ...