Click the lower part of the 
Show as Ranks button in the View group on the Table ribbon tab.
Select ranking type in the drop-down menu of the button:
Data ranking enables the user to order elements in table by their values.
NOTE. If totals are calculated, data can be ranked incorrectly. The user is prompted to disable totals calculation before ranking.
To execute data ranking:
Click the lower part of the Show as Ranks button in the View group on the Table ribbon tab.
Select ranking type in the drop-down menu of the button:
Descending rows.
Ascending rows.
Descending columns.
Ascending columns.
Entire table descending.
Entire table ascending.
To cancel data ranking, click the Show As Ranks button.
Source data:
Ranking in ascending order in the entire table:
See also: