Sort column in excel 2011 for mac by year when there are months included in the data

Using Z to A Sorting.Ĭonsider the same sales data and apply it to sort by following the below-mentioned procedure as follows. In these examples, we will try to sort out the sales data in a reverse order, i.e.

Choose the A to Z Sorting as shown below.First, select column B, a column named product name & apply the sorting.