It’s easy to sort a table in Excel, but you have to be careful! There are two important rules:
1. No empty cells in the table
2. Select only one cell or the entire table before you click on Sort
Wrong (only the selected names will be sorted):
Right (all
the names will be sorted, and Excel excludes the heading and the total
automatically):
The result: